34,590
社区成员
发帖
与我相关
我的任务
分享
select
SYUSER001.*,
baempy001_3.EMPNO,
baempy001_3.EMPNAME,
syuser001_1.USRNAME FSTUSRNAME,
syuser001_1.USRNO FSTUSRNO,
syuser001_2.usrname LSTUSRNAME,
syuser001_2.usrno LSTUSRNO,
BAEMPY001.EMPNAME FSTEMPNAME,
BAEMPY001.EMPNO FSTEMPNO,
baempy001_1.EMPNAME LSTEMPNAME,
baempy001_1.EMPNO LSTEMPNO
from SYUSER001
RIGHT OUTER JOIN BAEMPY001 AS baempy001_3 ON SYUSER001.EMPID = baempy001_3.IDNO
RIGHT OUTER JOIN SYUSER001 AS syuser001_1 ON SYUSER001.FSTUSRID = SYUSER001_1.IDNO
RIGHT OUTER JOIN SYUSER001 AS SYUSER001_2 ON SYUSER001.LSTUSRID = SYUSER001_2.IDNO
RIGHT OUTER JOIN BAEMPY001 ON SYUSER001.FSTEMPID = BAEMPY001.IDNO
RIGHT OUTER JOIN BAEMPY001 AS BAEMPY001_1 ON SYUSER001.LSTEMPID = BAEMPY001_1.IDNO