标题会吓退一批人。。 直接通过spkh,spys,spcm关联 select * from 入库单 a join 出库单 b on a.spkh=b.spkh and a.spys=b.spys and a.spcm=b.spcm join 调拨单 c on a.spkh=c.spkh and a.spys=c.spys and a.spcm=c.spcm .... 不知道你要的结果是啥
select *from 入库单 a join 出库单 b on a.spkh=b.spkh and a.spys=b.spys and a.spcm=b.spcm join 调拨单 c on c.spkh=b.spkh and c.spys=b.spys and c.spcm=b.spcm join 退货单 e on c.spkh=e.spkh and c.spys=e.spys and c.spcm=e.spcm join 销售单 f on e.spkh=f.spkh and e.spys=f.spys and e.spcm=f.spcm
直接通过spkh,spys,spcm关联
select * from
入库单 a join 出库单 b on a.spkh=b.spkh and a.spys=b.spys and a.spcm=b.spcm
join 调拨单 c on a.spkh=c.spkh and a.spys=c.spys and a.spcm=c.spcm
....
不知道你要的结果是啥
join 调拨单 c on c.spkh=b.spkh and c.spys=b.spys and c.spcm=b.spcm
join 退货单 e on c.spkh=e.spkh and c.spys=e.spys and c.spcm=e.spcm
join 销售单 f on e.spkh=f.spkh and e.spys=f.spys and e.spcm=f.spcm