Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How can I set up this select?
Thanks for your help.
Say I have 2 tables. One is a holding table with either new data to be inserted or updates to already existing data.
tableA_data_to_put_into_TableB
Name serial
tableB_to_be_updated_or_inserted_into
Name (PK_1) serial(PK_2)
Notice that TableA has no constraints. Thus an attempt to insert into TableB if "serial" is duplicated will of course fail.
My question is how to construct a select statement that will list all the records in tableA that have the same name and serial as in TableB --- but I don't know ahead of time the names or serials to put into the select's where clasuse.
Can someone help me?
Best,
Ken Sproule
kenmn_at_tds.net
Received on Sun Apr 02 2000 - 11:46:42 CDT
![]() |
![]() |