Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> join with criteria

join with criteria

From: gil guerillot <gil.guerillot_at_free.fr>
Date: Wed, 6 Feb 2002 19:11:49 +0100
Message-ID: <3c617279$0$16587$626a54ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US