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