Adding Multi-column IN clause support by SQL Server
Currrently, SQL Server does not support multi-column IN clause. For example, the following query :
Select * from tableA where (columnA, columnB) in select (columnX,columnY) from tableB
will not run, failing by displaying the error :
non-boolean type specified in a context where a condition is expected”

hi Mounaim
Thank you for the feedback. This is not planned for the moment. We will consider this for a future release.
thanks,
Dinakar