title: SQL Server: Select * from x where (a,b) in (select a,b from z)
body: <p>This does not work in SQL Server:</p>
  
  <pre><code>SELECT ID, SQNCNO
  FROM JUID AS MID
  WHERE 
       (ID, SQNCNO) IN (SELECT NM.ID, NM.SQNCNO
                        FROM JUNM AS NM
                        WHERE (LAST_NAME LIKE 'TESTCASE%')) 
  ORDER BY ID, SQNCNO
  </code></pre>
  
  <p>It works in DB2 and Oracle. The problem is <code>WHERE (ID, SQNCNO)</code>. Can anyone tell me how I can make this SQL work in SQL Server?</p>