and和or共存错乱，括号()前来帮忙调解

当语句中需要用到and 或or 需要表达“并且”“或者”这样的意思，要小心了很容易出现错误的。在适当的需要用到括号“（）”哟。

SELECT  *  FROM  mr_MeetingRegister

where meetingcode = 'MR12437' and

(AzCoordinatorEmplId in(select emplid from M_employee where linemgrid in(select emplid from M_employee where linemgrid = '05200213')) or AzCoordinatorEmplId  in(select emplid from M_employee where linemgrid = '05200213' ) or AzCoordinatorEmplId='05200213' )

转载于:https://www.cnblogs.com/BritneyComeOn/archive/2009/05/13/1456031.html