Hi,
I an under Oracle 19c. I have a SQL request that returns many rows for ATELIER:
select a.atelier,
b.*
from pa_atelier a
left join pa_atelier_liste_attente b
on a.id = b.id_spectacle
where a.id = 1
See, it returns 3 rows for ATELIER:

The table pa_atelier has only one row for ATELIER = ‘Poterie’
I would like it returns only one row for ATELIER:

How to improve the SQL request to achieve this ?
Best regards.