这两个查询之间的区别是什么?
SELECT f.name,
u.name,
u.id
FROM families f
JOIN units u
ON f.unit_id = u.id
HAVING u.id IN( 43, 413, 22 )
和:
SELECT f.name,
u.name,
u.id
FROM families f
JOIN units u
ON f.unit_id = u.id
WHERE u.id IN( 43, 413, 22 )
这两个查询的结果完全相同。那么,区别在哪里呢?
https://stackoverflow.com/questions/16155937
复制相似问题