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 -> Select Queries

Select Queries

From: Arthur Merar <amerar_at_unsu.com>
Date: Thu, 04 Mar 1999 05:18:21 GMT
Message-ID: <36de169c.9384615@news.chaven.com>

Hello,

I am having trouble creating a query that will select all records in one table that do NOT have a matching record in another table.....

I tried something like this:

Insert into INT_POHEADER
  ponum, podate
  (Select * from TMP_POHEADER where
 ponum NOT IN (select * from POHEADER))

Can anyone help me out?

Thanks,

Arthur
amerar_at_unsu.com Received on Wed Mar 03 1999 - 23:18:21 CST

Original text of this message

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