Checking If A Value In A Column In One Table Appears In A Column In Another Table

[curlydog]

I'm trying to query a database (oracle) which I've created via SQL.

It relates to an ordering system which tracks from a quote to invoicing. Obviously not all quotes are turned into orders. This is what I'm trying to find, which quotes are not ordered.

I have a Quote table with quoteID as the PK. I have another table Order which has a foreign key quoteID which references Quote.

Can anyone tell me how I find the records in Quote which do not appear in Order.

Thanks
CUDOG

[Markus]

Try the following:

SELECT quoteID from quotes
WHERE NOT EXISTS
(SELECT quoteID from Orders
Where orders.quoteid = quote.quoteID)