34,571
社区成员
发帖
与我相关
我的任务
分享
select
a.bill_no,
b.b_id,b.id,b.qty,b.price,
c.c_id,c.id,c.qty,c.price
from a
left join b on(a.a_ID=a.BILL_ID)
left join c on(c.c_id=b.bill_id and b.qty=c.qty and c.price=b.price)
where isnull(a.BILL_TYPE,'')='INV016'