2022/8/3 询价单列表展示

列表展示"/>

2022/8/3 询价单列表展示

/**询价单**/
SELECT 
c1.buyer_vender_id,c1.buyer,c1.buyer_name,c1.seller_vender_id,c1.`status`,c1.past_date,c1.seller,c1.seller_name,
c2.buyer_price,c2.tax_flag,
c3.material,c3.width,c3.thickness,weight
from
vender_enquiry c1
left Join vender_enquiry_detail c2
on c1.id=c2.enquiry_id
left JOIN vender_volume c3
on c2.vender_volume_id=c3.id
where c1.buyer_vender_id = 119 or c1.seller_vender_id=119;