Skip to Content
0
Jul 28, 2020 at 11:59 AM

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

735 Views

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