62,074
社区成员
发帖
与我相关
我的任务
分享
SELECT A.ID, A.TR_EmpID, A.TR_EmpCode, A.TR_EmpName, A.TR_EmpNumber, A.TR_CourseID, A.TR_CourseCode, A.TR_CourseName,
A.TR_CourseValidDateStr, A.TR_CourseValidDate,A.TR_ID, TR_Code, A.TR_Name, A.TR_StartDate, A.TR_EndDate, A.TR_Content,
A.TR_OrgName, A.TR_Mode, A.TR_Category, A.TR_SumCourseTime, A.TR_Score, A.TR_Result,A.TR_TechersName, A.TR_HasReatTR,
A.TR_DepID, A.TR_DepName, A.TR_RecordSource, A.TR_RecordDate, A.TR_RecordStatus, A.TEACHERTYPE, A.isdeleted,B.JOINCOMPANTTIME,
B.OUTCOMPANTTIME,B.EMPSTATUS,B.STATUSNAME,TE.ID AS TEID
FROM View_TRAINNING_RECORD A,View_Employee B,dbo.TRAINNING_EMPS TE
WHERE A.TR_EmpID=B.EMPLOYEEID AND A.TR_ID=TE.TR_ID AND A.TR_EmpID=TE.TR_EMPID
SELECT ...
FROM
(SELECT ...
FROM View_TRAINNING_RECORD A,View_Employee B
WHERE A.TR_EmpID=B.EMPLOYEEID) T
LEFT JOIN
dbo.TRAINNING_EMPS TE ON T.TR_ID=TE.TR_ID AND T.TR_EmpID=TE.TR_EMPI