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 TJOIN 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 = 2052LEFT JOIN dbo.T_META_OBJECTTYPE_L T3 ON T.FTARGETFORMID = T3.FID AND T3.FLOCALEID = 2052WHERE T1.FLOCALEID = 2052AND T2.FNAME LIKE '%分步式%'AND T3.FNAME LIKE '%分步式%'

标签: none

添加新评论