销售订单新变更单新增的行关联查询销售订单-526互联

SELECT t2.FENTRYID ,
t2.FSEQ ,
t2.FMATERIALID ,
T3.FENTRYID ,
T3.FSEQ ,
T3.FMATERIALID ,
t21.FROWID
FROM T_SAL_XORDER t1
JOIN T_SAL_XORDERENTRY t2 ON t1.FID = t2.FID
LEFT JOIN T_SAL_XORDERENTRY_E t21 ON t2.FID = t21.FID
AND t2.FENTRYID = t21.FENTRYID
LEFT JOIN T_SAL_ORDERENTRY_E T31 ON T31.FROWID = t21.FROWID
LEFT JOIN T_SAL_ORDERENTRY T3 ON T3.FID = T31.FID
AND T3.FENTRYID = T31.FENTRYID
WHERE FBILLNO = 'XSDD000297_V001'