将 X++ SQL 代码转换为 SQL Server 代码

SELECT * FROM IdcfPurchApprovalInfo LEFT OUTER JOIN IdcfCodeLine AS IdcfCodeLine_1 ON (IdcfPurchApprovalInfo.IdcfDrafterDept = IdcfCodeLine_1.IdcfCodeFreeStrSpace2 AND (IdcfCodeLine_1.IdcfCodeFreeStrSpace2 = '13' OR IdcfCodeLine_1.IdcfCodeFreeStrSpace2 = '' OR IdcfCodeLine_1.IdcfCodeFreeStrSpace2 = '')) LEFT OUTER JOIN IdcfCodeLine AS IdcfCodeLine_1_1 ON (IdcfPurchApprovalInfo.IdcfDrafterDept LIKE IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 + '%' AND (IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '13' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '')) WHERE (IdcfPurchApprovalInfo.IdcfDrafterDept != '' AND (IdcfPurchApprovalInfo.IdcfDrafterId = 'hongmin.liang' OR IdcfPurchApprovalInfo.IdcfApplicantId = 'hongmin.liang')) GROUP BY IdcfPurchApprovalInfo.IdcfPurchOrderId HAVING IdcfPurchApprovalInfo.IdcfDrafterDept != ''