Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Select Queries
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