title: T-SQL "Where not in" using two columns
body: <p>I want to select all records from a table T1 where the values in columns A and B has no matching tuple for the columns C and D in table T2.</p>
  
  <p>In <a href="https://stackoverflow.com/questions/8435107/mysql-where-not-in-using-two-columns">mysql “Where not in” using two columns</a> I can read how to accomplish that using the form select A,B from T1 where (A,B) not in (SELECT C,D from T2), but that fails in T-SQL for me resulting in "Incorrect syntax near ','.".</p>
  
  <p>So how do I do this?</p>