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

[Markus]

Try the following:

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