SELECT UOutStorage.FOutId, UOutStorage.FDate,
UDept_A.FDeptName AS FDrawDept, UDept_B.FDeptName AS FDeliverDept,
USysUsers_A.FUserName AS FOfficer, USysUsers_B.FUserName AS FVerify,
USysUsers_C.FUserName AS FOut, USysUsers_D.FUserName AS FIn
FROM UOutStorage LEFT OUTER JOIN
USysUsers USysUsers_D ON
UOutStorage.FIn = USysUsers_D.FUserId LEFT OUTER JOIN
USysUsers USysUsers_C ON
UOutStorage.FOut = USysUsers_C.FUserId LEFT OUTER JOIN
USysUsers USysUsers_B ON
UOutStorage.FVerify = USysUsers_B.FUserId LEFT OUTER JOIN
USysUsers USysUsers_A ON
UOutStorage.FOfficer = USysUsers_A.FUserId LEFT OUTER JOIN
UDept UDept_B ON
UOutStorage.FDeliverDept = UDept_B.FDeptID LEFT OUTER JOIN
UDept UDept_A ON UOutStorage.FDrawDept = UDept_A.FDeptID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货