sql question

[MrDontKnowNothing]

hi folks,

how can i obtain all records, wich are in table "A" and not in table "B"?

(select * from A where A.key not in (select B.key from B))

gracias

alex

 

[Mike Gagnon]

Were the examples in the Help file not answering your request?

SELECT customer.company, orders.order_id, orders.emp_id ;
   FROM customer, orders ;
   WHERE customer.cust_id = orders.cust_id ;
UNION ;
   SELECT customer.company, 0, 0 ;
   FROM customer ;
   WHERE customer.cust_id NOT IN ;
   (SELECT orders.cust_id FROM orders)

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[MrDontKnowNothing]

thanks a lot!

alex

 

[BPeisch]

Hi Alex,

It seems you posted the statement you need in your original message. Didn't that give you the results you were expecting?



-BP

http://www.peisch.com