34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT distinct a.crdt,a.crus,a.crna,a.biid,a.orid,o.biid as obiid,i.gco,i.gna,o.gqty,o.tqty from ltma a
LEFT JOIN inve i on a.crus=i.crco
LEFT JOIN oubd o on i.gco=o.inco
SELECT DISTINCT
a.crdt ,
a.crus ,
a.crna ,
a.biid ,
a.orid ,
o.biid AS obiid ,
i.gco ,
i.gna ,
o.gqty ,
o.tqty
FROM ltma a
LEFT JOIN inve i ON a.crus = i.crco
LEFT JOIN oubd o ON i.gco = o.inco