OT SQL Question ?

["Dr John Tankard" <john@xxxxxxx>]

I have left my SQL ref at home

Two tables Quotes & Orders

Quotes
------
QuoteID
Booked(y/n)

Orders
------
OrderID
QuoteID

I want to list all Quotes that Booked = T that dont exist in Orders ?

I know I need a subquery and a IN or Exist but canntot remember how 
to form it

John

Yahoo! Groups Sponsor

ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.