Select A.empid,A.name,C.lastdate,D.attdate from emp A Left Join loadname B On A.name=B.empname Left Join setting C On B.loadname=C.loadname Left Join att D On A.empid=D.empid Order By A.empid
试试Select A.empid, A.name, C.lastdate, D.attdate, (Case When D.attdate Is Null Then N'没有打卡' When C.lastdate>=D.attdate Then N'正常' Else N'迟到' End) As '打卡情况' from emp A Left Join loadname B On A.name=B.empname Left Join setting C On B.loadname=C.loadname Left Join att D On A.empid=D.empid Order By A.empid
from emp A
Left Join loadname B On A.name=B.empname
Left Join setting C On B.loadname=C.loadname
Left Join att D On A.empid=D.empid
Order By A.empid
A.empid,
A.name,
C.lastdate,
D.attdate,
(Case When D.attdate Is Null Then N'没有打卡' When C.lastdate>=D.attdate Then N'正常' Else N'迟到' End) As '打卡情况'
from emp A
Left Join loadname B On A.name=B.empname
Left Join setting C On B.loadname=C.loadname
Left Join att D On A.empid=D.empid
Order By A.empid