I have 2 tables: Main table with maybe 100,000+ rows and a Table1 with maybe 2000 rows.
I need to compare Table1 with the main table.
1. If ID field in Table1 already exists in the Main table, then update that row in the Main table. 2. If ID in Table1 doesnt exists in Main table, then insert the row from Table1 into Main table.
Do I need to loop thru Main and Table1??