Quick question:

how can i make this sql statement:

SELECT table1.field1, table1.field2 FROM table1 WHERE field1 DOES NOT EQUAL table2.field1

basically i want to only select records from table1 that do not exist in table2

any help will be greatly appreciated,
thanks in advance,

Jonah

OK then,

ill answer this myself:

SELECT [table1].[field1] FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE [table2].[field1] = [table1].[field1])

hope this helps

you could also do....

SELECT [table1].[field1] FROM table1
WHERE Table1.field1 NOT IN (SELECT [table2].Field1 FROM table2)

hope this helps

thanks rokslide,

that looks like a good option as well.

Jonah