Re: OT SQL Question ?

[steve.cooper@xxxxxxx]

Select *
>from
where Booked = T and QuoteID not in (Select OuoteID from Orders)

S.



                                                                                                                                               
                   
"Dr
John                                                                                                                   
                   
Tankard"            
To:    
ukha_d@xxxxxxx                                                                        
                   
<john@sawood.       
cc:                                                                                                   
                   
co.uk>              
Subject:     [ukha_d] OT SQL Question
?                                                               
                                                                                                                                               
                   
02/10/02                                                                                                                   
                   
15:07                                                                                                                      
                   
Please                                                                                                                     
                   
respond
to                                                                                                                 
                   
ukha_d                                                                                                                     
                                                                                                                                               
                                                                                                                                               



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



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 http://docs.yahoo.com/info/terms/








___________________________________________________________________________

The information contained in this message is confidential and may be 
legally privileged. If you are not the intended recipient, please do not
read, copy or otherwise use it and do not disclose it to anyone else. 
Please notify the sender of the delivery error and then delete the 
message from your system. 

Any views or opinions expressed in this email are those of the author
only.

Communications will be monitored regularly to improve our service and
for
security and regulatory purposes.

Thank you for your assistance.

___________________________________________________________________________

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.