Skip to Content
author's profile photo Nida Khan
0
Nida Khan

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

Posted on Jul 28, 2020 at 11:59 AM 276 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

Add a comment
10|10000 characters needed characters exceeded

  • Sandra Rossi
    Jul 28, 2020 at 12:15 PM

    There are 0 to any number of lines in EKPO for each line in EKKO. If you want to output only one line of EKPO, what is the selection criteria to choose between those possible lines of EKPO? (If you answer "any line", please tell us why do you want something random?)

    Please provide your code, that will certainly help us understand.

Assigned Tags

Related questions

1 Answer

  • author's profile photo Mateusz Adamus
    Mateusz Adamus
    Posted on Jul 28, 2020 at 12:03 PM
    2

    Hello Nida Khan

    Use SELECT SINGLE or UP TO n ROWS.

    Kind regards,
    Mateusz
    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.