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