Re: URGENT Join question

You must be something wrong. Theoridically this query is going to compare each row in table2 with all rows in table1 and return those which match the condition. So the result should be 'Hello World 1'. Actually I run this query to verify this and it did. For better understanding, you can run the following query:

select distinct b.col1, b.col2, a.col1, a.col2 from table2 b, table1 a
where b.col1 <> a.col1 and
a.col2 = b.col2;

Also try to insert one more row to table1 like ('Test', 1) and run the above query again.... Received on Thu Aug 09 2001 - 11:27:12 CDT