SELECT T001W~WERKS, LGORT, LGOBE INTO TABLE @DATA(LT_T001W) FROM T001W LEFT JOIN T001L ON T001W~WERKS = T001L~WERKS AND T001L~WERKS LIKE '11%' WHERE T001W~WERKS LIKE '1%'.
Left Join 时筛选条件在on后与where后的区别
内容版权声明：除非注明，否则皆为本站原创文章。
SELECT T001W~WERKS, LGORT, LGOBE INTO TABLE @DATA(LT_T001W) FROM T001W LEFT JOIN T001L ON T001W~WERKS = T001L~WERKS AND T001L~WERKS LIKE '11%' WHERE T001W~WERKS LIKE '1%'.
内容版权声明：除非注明，否则皆为本站原创文章。