MySQL查询的WHERE条件问题
问题描述:
我有一个工作查询作为MySQL查询的WHERE条件问题
SELECT p.id,
p.name AS ProductName,
count(DISTINcT s.salesid) as Sales,
Count(DISTINCT l.linkid) as Links
FROM products p
LEFT JOIN sales s ON p.id=s.productid
LEFT JOIN links l ON p.id=l.productid
GROUP BY p.id
现在,我只需要那些记录,或者销售不等于0或链接不等于0或两个不等于0
我该如何做到这一点?
答
添加HAVING子句
SELECT p.id, p.name AS ProductName,
count(DISTINcT s.salesid) as Sales, Count(DISTINCT l.linkid) as Links
FROM products p
LEFT JOIN sales s ON p.id=s.productid
LEFT JOIN links l ON p.id=l.productid
GROUP BY p.id
HAVING Sales > 0 OR Links > 0
它的工作原理,谢谢 – 2010-12-13 05:50:07