>Hi all,
>
>I have 2 tables from flat files that I have to compare if they have the same addresses:
>
>table1 with 3 fields
>streetnum streetname city
>
>12345 bob ave New City
>
>table2 with 3 fields
>streetnum streetname city
>
>12345 bob ave New City
>
>My sql syntax is :
>
>select * from table1 where streetnum in ( select streetnum from table2 ) and streetname in (select streetname from table2) and
>city in (select city from table2) into cursor table3.
>
>Please correct my sql syntax because it is not working now and the city's length are not the same for table1 and table2.
>
>Thanks in advance,
Select t1.* ;
From table1 t1 ;
INNER Join table2 t2 ;
ON Upper(t1.streetnum) == Upper(t2.streetnum) And ;
UPPER(t1.streetname) == Upper(t2.streetname) And ;
UPPER(t1.city) == Upper(t2.city)
Cetin