高手帮帮忙看看ＳＱＬ语句

Question

=。=  能用&吗？应该是and吧

Answer 1

select xm,dept,uname,phone 
   from yuangong 
      where uname in(
                       select uname from compact 
                            where datepart(day,outtime)=datepart(day,getdate())
                            and datepart(month,outtime)= datepart(month,getdate())
                     )
重名就会得到错误结果
建议用ID关联