I'm trying to insert records from one database table to another database table where a record does not exist. So if db2.tbA record exists insert into db1.tblA. My current syntax looks something like:
INSERT INTO db1.dbo.tblA([Col1] ,[Col2] ,[Col3])
Where Not Exists (SELECT [Col1] ,[Col2] ,[Col3] FROM db2.dbo.tblA Where Col4 is null)
I'm getting a syntax error at the where not exists. What am I doing wrong?
