Updating two tables
Col1 IN (21, 31) GOMy Query which executed:: UPDATE t1 SET t1.
Pinal is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).
When asked the reason was he had no idea how to use multiple tables with the help of the JOIN clause in the UPDATE statement. Additionally, we want to update the values of Col2 and Col3 only.
If any row in the #Updated Data table, except for Member ID or Location ID is different that Update #Original Data row with the same row in the #Updated Data table. But if I just query the two tables, I am getting a huge number of rows back, when I know there are only two rows that are different between the two tables.