最好按标准来写,源表使用别名,这样可以简化命令行,越简单越不容易打错字
SELECT A.*, B.qty as (B(j)) FROM &y A LEFT JOIN &x B ON A.bjh = B.bjh AND A.dpt = B.dpt INTO CURSOR ...
SELECT A.*, B.qty as (B(j)) FROM &y A LEFT JOIN &x B ON A.bjh = B.bjh AND A.dpt = B.dpt INTO CURSOR ...
[此贴子已经被作者于2023-10-18 18:59编辑过]

这家伙很懒,啥也没留下