Hello, please tell me, I need to choose news those of users whose number of reviews > 1
as a result of this I have 3 tables: comments, news, users
The structure of the table users:
The structure of the table news:
Structure table comments:
For example here is a table filled with comments like this:
Doing such a query:
GROUP BY comments.user_id
HAVING COUNT(comments.user_id) > 1
Get the result:
Everything seems right, the query returns the id of those users who left more than one comment, but I need another job to bring them news, and please tell me how you can still find the news of these users ? I understand that I need to dig in the direction of join and subquery ?
Thank you for your answer.