appending data

[747576]

Hi,

I have a table with data I want to append to another table. The new table (table 2) contains updated records from the original table (table 1). I need to run a query which will use the table 2 to extract the corresponding data from the original table 1 so I can delete the records and append the new records (I dont want to duplicate records). I can query the records using certain fields, ie field1, field2 which will distinguish the records. I've tried a union but need more help.

thanks

 

[tlbroadbent]

Select rows in table1 that are on table2.

Select t1.*
From table1 t1
Join table2 t2
On t1.field1=t2.field1
And t1.field2=t2.field2

Delete rows in table1 that are on table2.

Delete table1
From table1 t1
Join table2 t2
On t1.field1=t2.field1
And t1.field2=t2.field2

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.