SELECT distinct --加上这个 h.username, g.Enterprisename, d.chinaname, d.chinaspec, d.merchandise, f.brand, f.Produce_Factory, f.Newprice, f.Minpacking, e.unitname, b.price, b.lastprice, c.bidid, a.drexpertid, c.zbxh, h.userpurview FROM dbo.drexpert_type a LEFT OUTER JOIN dbo.user_product b ON b.bidid = a.bidid LEFT OUTER JOIN dbo.bid_product c ON c.bidid = b.bidid AND b.bid_productID = c.id LEFT OUTER JOIN dbo.product_basic d ON d.id = c.product_basicid LEFT OUTER JOIN dbo.unit e ON d.unitid = e.id LEFT OUTER JOIN dbo.product_qt f ON f.user_productid = b.id LEFT OUTER JOIN dbo.EnterpriseBasicInfor g ON g.userid = b.userid LEFT OUTER JOIN dbo.bid_user h ON h.id = b.userid AND h.bidid = a.bidid LEFT OUTER JOIN dbo.bid_type i ON i.bidid = a.bidid AND a.bid_typeid = i.id
distinct --加上这个
h.username, g.Enterprisename, d.chinaname, d.chinaspec, d.merchandise, f.brand,
f.Produce_Factory, f.Newprice, f.Minpacking, e.unitname, b.price, b.lastprice, c.bidid,
a.drexpertid, c.zbxh, h.userpurview
FROM dbo.drexpert_type a LEFT OUTER JOIN
dbo.user_product b ON b.bidid = a.bidid LEFT OUTER JOIN
dbo.bid_product c ON c.bidid = b.bidid AND b.bid_productID = c.id LEFT OUTER JOIN
dbo.product_basic d ON d.id = c.product_basicid LEFT OUTER JOIN
dbo.unit e ON d.unitid = e.id LEFT OUTER JOIN
dbo.product_qt f ON f.user_productid = b.id LEFT OUTER JOIN
dbo.EnterpriseBasicInfor g ON g.userid = b.userid LEFT OUTER JOIN
dbo.bid_user h ON h.id = b.userid AND h.bidid = a.bidid LEFT OUTER JOIN
dbo.bid_type i ON i.bidid = a.bidid AND a.bid_typeid = i.id