Z-Blog liuyb

SELECT T1.FNAME AS '转换规则名称',T2.FID AS '原单FromId',T2.FNAME AS '原单名称',T3.FID AS '目标单FromId',T3.FNAME AS '目标单名称',T.FID AS '单据转换规则'
FROM T_META_CONVERTRULE T
JOIN dbo.T_META_CONVERTRULE_L T1 ON T1.FID = T.FID 
LEFT JOIN dbo.T_META_OBJECTTYPE_L T2 ON T.FSOURCEFORMID = T2.FID AND T2.FLOCALEID = 2052
LEFT JOIN dbo.T_META_OBJECTTYPE_L T3 ON T.FTARGETFORMID = T3.FID AND T3.FLOCALEID = 2052
WHERE T1.FLOCALEID = 2052
AND T2.FNAME LIKE '%分步式%'
AND T3.FNAME LIKE '%分步式%'