mysql - 从单独的表中查找 (UNIQUE VALUE, VALUE1, VALUE2) 的值

Question

当前尝试连接表并总结重复项，返回满足 3 个条件的总值。

SELECT p.name, p.place, h.hotel
FROM travel AS p
INNER JOIN hotels AS h ON p.id = h.id
HAVING p.place = 'city' AND hotel = 'bad'
ORDER BY p.name

我想办法让 p.name, p.place, h.hotel > 1 (UNIQUE) (SAME VALUE) (SAME VALUE)

当前返回的是

ted,   1, 2
greg,  1, 2
harry, 1, 2
angel, 1, 2

试图返回 4。

标签： mysqlmysql-workbench