sql语句优化问题求教
EmpPostRecord.vcLevelName,
EmpPostRecord.vcAdminLevelName,
EmpPostRecord.vcTechLevelName,
CONVERT(char(10), tbCLaborRelation.dBeginTime, 120) AS dBeginTime,
CASE tbContract.iTermType
WHEN '3' THEN '无固定期'
WHEN '4' THEN '完成一定工作'
ELSE CONVERT(char(10), tbCLaborRelation.dEndTime, 120)
END AS dEndTime,
tbOrganDirectory.vcFullName AS vcContractOrganName,
tbContract.iCo
这段语句有哪些可优化之处啊?