Sql - how to make a selection of the main record and all related ones in one query?

Question

MySQL

Hello!
Help me to understand.
There is a table of events, there is a table of clients registered for it with additional information (place, comment, and so on).
Is it possible to get an event and an array of rows from the second table with one query?
Experience with sql is small, using join I see a solution only through duplication of event records.

Answer 1

yes, only with duplication of event records. "LEFT JOIN" -> Google