sneumersky (3/3/2014)
I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my breath....
Yeah, I wish the SQL language standard incorporated
INSERT CORRESPONDING INTO a
SELECT * FROM b
Well, there is a way around it...