SQLServer中实现Oracle多列条件in
??? 在Oracle中可以定义多列条件在in查询中,如下:
select * from dept d inner join emp e on d.dname = e.ename and d.loc = e.job;
?