mysql查询多个表中多个数据,MySQL查询从多个表中获取数据

I have following tables

1) Products (productid, name, description, price)

2) Sales (salesid, productid, buyername, buyeremail, status)

3) ProductViews (viewid, productid)

Now, I need a query that can output as

ProductID     ProductName     Price     TotalViews     TotalSales

Help appreciated, thanks.

解决方案SELECT p.productid, p.name, p.price, COUNT(pv.viewid) AS totalviews, COUNT(s.salesid) AS totalsales

FROM Products p

LEFT JOIN Sales s ON s.productid = p.productid

LEFT JOIN ProductViews pv ON pv.productid = p.productid

GROUP BY p.productid, p.name, p.price

Extended group by for completeness sake but it could just be p.productid.