Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> join with criteria
I have 2 tables :
orders and orderlines
fields:
code ---------+ order
status line supplier
i want to select all the orders code in order table where there is no line
with the 2 criterias
order.status='A' and orderline.supplier ='XXX'
what is the good SQL select?
thanks Received on Wed Feb 06 2002 - 12:11:49 CST