mysql - 选择在其他表中有不止一次经验的用户

Question

表 tblusers:

+-------------+---------------+----------+
| id_users    | user          | password |
+-------------+---------------+----------+
| 1           | gurodrigues   | 1234     |
| 2           | lower52       | 123      |
| 3           | test55        | 1234     |
+-------------+---------------+----------+

表tblexperiences:

+----------------+-----------+-------------------+
| id_experience  | id_users  | detail            |
+----------------+-----------+-------------------+
| 1              | 1         | 'Cool, fantastic' |
| 2              | 1         | 'Nice!!'          |
| 3              | 2         | 'Boring'          |
+----------------+-----------+-------------------+

SELECT tblusers.id, tblusers.user from tblusers, tblexperiences WHERE tblexperiences.id = tblusers.id

如果我先执行此操作，SELECT 会返回很多重复的行，但我只需要一次，我该怎么做？

在另一个 SELECT 中，我必须让所有用户都在 tblexperiences WHERE 有不止一行 tblexperiences.id_users

Answer 1

SELECT tblusers.id, tblusers.user 
from tblusers
join tblexperiences ON tblexperiences.id = tblusers.id
group by tblusers.id, tblusers.user 

对于问题的第二部分，添加一个

having count(tblexperiences.id) > 1