根据采购单单身的采购单别单号序号查询此项采购单对应的所有到货信息:(需用SQL生成视图)

2024-11-15 07:03:03
推荐回答(2个)
回答1:

到货单PURCC为主表,外联结采购单PURTD即可

回答2:

select * from purtd as p1 left join purcc as p2 on p1.td001=p2.cc010 and p1.td003=p2.cc003