Select

archVille · #1 (**permalink**) 12-16-05, 18:20

How do we compare 2 tables country1(name1,..,...) and country2(name2,...,...) so that we want find a value that is in name1 not in whole name2 ???
When i try to do this by select it returns me all the values that are not equal to name1 from name2 and it doesn't just search for example if 'Greece' is in name2 or not but just if 'Greece' is equal with x1,x2,x3,x4,..,... from name2 .

I am a bit stuck here...

jfulton · #2 (**permalink**) 12-17-05, 17:15

like this?

Code:

SELECT * 
FROM table1 
WHERE field1 NOT IN (SELECT DISTINCT field2 FROM table2)

Internet Services

Web Development

Digital Marketing

Consumer Tech