I have two identical tables in my SQL Server database (format is identical not data content). Table B has a number of rows in it that do not appear in Table B. My goal is to move those rows from Table B into Table A. Will the following SQL work for that or do I need to take a different approach?
Insert Into TableA
Select * from TableB
Left Outer Join TableA
On TableA.Column1 = TableB.Column1 And TableA.Column2 = TableB.Column2
Where TableA.Column 1 is null
Let me know if this SQL will work for that or if I need to try something different.
Thanks, in advance, for your help.