[Resolved] Display records from table 1 that do not exist in table 2

[BigE]

I am sure this is very simple, but I cannot for the life of me think of what to search for in order to get the syntax.

I want to display all records from table 1 that do not have an entry in table 2.

So...

Table 1

Apples
Oranges
Grapes
Bannanas

Table 2

Apples
Grapes

I want a query on table 1 that will only result in:

Oranges
Bannanas

SImple right?

-E

[LordShryku]

SELECT field1 
FROM table1
WHERE field1 NOT IN ( 
    SELECT field1 FROM table2
)

Gotta have a version that supports subqueries for this[code

[BigE]

I couldn't make that work. I did some more research on outer joins and found the following solution:

SELECT * FROM Table1 LEFT JOIN Table2 USING (Fruit) WHERE Table2.Fruit IS NULL

Thanks though.

-E