SELECT Q.ID,Q.Code,Q.Name,CardNo,PyDate,sSex=(CASE Sex WHEN 0 THEN '男' ELSE '女' END),sDept=D.LongName,sZhiWu=ZW.Name,sZhiJi=ZJ.Name,IfPb=(case when PB.SessionID is null...
SELECT Q.ID,Q.Code,Q.Name,CardNo,PyDate,sSex=(CASE Sex WHEN 0 THEN '男' ELSE '女' END),sDept=D.LongName,sZhiWu=ZW.Name,sZhiJi=ZJ.Name,IfPb=(case when PB.SessionID is null...