Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to return only one row with a left join in a SQL request

Christian Pitet.Jul 28 2026 — edited Jul 28 2026

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.

This post has been answered by F.Eicken on Jul 28 2026
Jump to Answer
Comments
Post Details
Added on Jul 28 2026
6 comments
143 views