Re: Comparing two tables

[Nick Roper]

Hi Natasha,

> Table2 has only 20 rows, 2 columns; one of its columns is an identifier and the other is made up of periods similar to those in the first table.

If the column definitions for Table2.Period and Table1.Period are similar, then wouldn't you need to compare rounded values from both tables? e.g.:

SELECT Table1.Period, Table2.Period, Table2.ID FROM Table1, Table2 WHERE ROUND(Table1.Period,3)=ROUND(Table2.Period,3);

Or are the column definitions and data values different?

If so, can you post the table definitions:

mysql> SHOW CREATE TABLE Table1;
mysql> SHOW CREATE TABLE Table2;

and also some example data from both tables (particularly where you would expect the join to work)







--
Nick Roper