Very simple MSSQL syntax question
Posted on 2009-04-11
Why does this query give me a syntax error in MS SQL Server?
select dv_id, dp_id from em where dv_id, dp_id not in (select dv_id, dp_id from dp)
I'm just trying to check for invalid data for a foreign key referencing a two-part primary key.
What is the correct syntax for this? Thanks in advance.