多表查询的例子

select a.supplierid,a.bill_number,a.time,b.pid,b.bar_code,b.estimate_num,b.actual_num,c.name,c.cost_price,d.supplier_name from ims_sibox_purchase as a left join

ims_sibox_purchase_list as b on a.id=b.pid left join

ims_sibox_goods_setting as c on b.bar_code=c.bar_code left join

ims_sibox_supplier as d on a.supplierid=d.id where a.id="9";