there 2 identical tables and one has more records than another. I want to insert those records to the table that has less records.
USE GIS GO INSERT INTO Xcobadds SELECT * FROM Xcobadds_V WHERE Xcobadds.UID_NUM <> Xcobadds_V.UID_NUM
however I got error message like this.
Msg 4104, Level 16, State 1, Line 4 The multi-part identifier "Xcobadds.UID_NUM" could not be bound.