How to use LEFT OUTER JOIN to get only one matching row from second table in Open SQL ?

Hi ,

For example i am using EKKO table Left Outer Join EKPO but based on multiple entries in EKPO, i am getting multiple items.

I only need to return one matching row from second table that is EKPO.

How will i achieve this in Open SQL

Thanking You