Join error 'The elements in the "SELECT LIST" list must be separated using commas'

[Former Member]

I have a join that is getting this error when I do a syntax check. I have a very similar join on more tables that works fine. Can anyone tell what is causing the issue?

TYPES: BEGIN OF ty_main,

          kunnr TYPE kna1-kunnr,

          name1 TYPE kna1-name1,

          name2 TYPE kna1-name2,

          stras TYPE kna1-stras,

          ort01 TYPE kna1-ort01,

          regio TYPE kna1-regio,

          pstlz TYPE kna1-pstlz,

          land1 TYPE kna1-land1,

          telf1 TYPE kna1-telf1,

          telfx TYPE kna1-telfx,

     str_suppl1 TYPE adrc-str_suppl1,

     str_suppl2 TYPE adrc-str_suppl2,

     str_suppl3 TYPE adrc-str_suppl3,

          kdkg1 TYPE kna1-kdkg1,

          sort1 TYPE adrc-sort1,

          sort2 TYPE adrc-sort2,

          erdat TYPE kna1-erdat,

          ernam TYPE kna1-ernam,

          ktokd TYPE kna1-ktokd,

          vkorg type knvv-vkorg,

          vtweg type knvv-vtweg,

          spart type knvv-spart,

          aufsd type kna1-aufsd,

          aufs2 type knvv-aufsd,

          lifsd type kna1-lifsd,

          lifs2 type knvv-lifsd,

          faksd type kna1-faksd,

          faks2 type knvv-faksd,

          loevm type kna1-loevm,

          loev2 type knvv-loevm,

        END OF ty_main.

Data:  it_main     TYPE TABLE OF ty_main.

SELECT kna1~kunnr kna1~name1 kna1~name2 kna1~stras kna1~ort01

          kna1~regio kna1~pstlz kna1~land1 kna1~telf1 kna1~telfx

          adrc~str_suppl1 adrc~str_suppl2 adrc~str_suppl3

          kna1~kdkg1 adrc~sort1 adrc~sort2 kna1~erdat kna1~ernam

          kna1~ktokd knvv~vkorg knvv~vtweg knvv~spart kna1~aufsd

          knvv~aufsd kna1~lifsd knvv~lifsd kna1~faksd knvv~faksd

          kna1~loevm knvv~loevm

     INTO TABLE it_main

     FROM kna1

     LEFT OUTER JOIN knvv ON kna1~kunnr = knvv~kunnr

     LEFT OUTER JOIN adrc ON kna1~adrnr = adrc~addrnumber

    WHERE kna1~kunnr IN s_kunnr

      AND kna1~name1 IN s_name1

      AND kna1~name2 IN s_name2

      AND kna1~stras IN s_stras

      AND kna1~ort01 IN s_ort01

      AND kna1~regio IN s_regio

      AND kna1~pstlz IN s_pstlz

      AND kna1~land1 IN s_land1

      AND kna1~telf1 IN s_telf1

      AND kna1~telfx IN s_telfx

      AND adrc~str_suppl1 IN s_strt2

      AND adrc~str_suppl2 IN s_strt3

      AND adrc~str_suppl3 IN s_strt4

      AND kna1~kdkg1 IN s_kdkg1

      AND adrc~sort1 IN s_sort1

      AND adrc~sort2 IN s_sort2

      AND kna1~erdat IN s_erdat

      AND kna1~ernam IN s_ernam

      AND kna1~ktokd IN s_ktokd

      AND knvv~vkorg IN s_vkorg

      AND knvv~vtweg IN s_vtweg

      AND knvv~spart IN s_spart

      AND kna1~aufsd IN s_aufsd

      AND knvv~aufsd IN s_aufs2

      AND kna1~lifsd IN s_lifsd

      AND knvv~lifsd IN s_lifs2

      AND kna1~faksd IN s_faksd

      AND knvv~faksd IN s_faks2

      AND kna1~loevm IN s_loevm

      AND knvv~loevm IN s_loev2.

[former_member770121]

if your probelm is resolve then please recommend a solution i am also facing the same error????????? i have apply left outer join with inner join .

[Former Member · Accepted solution]

I had no syntax error when I tried this with only the first two SELECT-OPTIONS. Try that as a first step.

Rob

[nikolayevstigneev · Accepted solution]

Two similar questions for a day

Rob, I managed to reproduce the error on a 7.40 system. It seems that he doesn't like where-conditions for the right table. If I leave only kna1 restrictions it's ok. If I add any of the right-side tables I get the mentioned warning.

[nikolayevstigneev · Accepted solution]

... and here what the doc says:

In outer joins, all comparisons that contain columns from the database table or view dbtab_right on the right side (as an operand) must be specified in the associated join condition. These columns are not allowed as operands in the WHERE condition of the same SELECT statement.

[Former Member · Accepted solution]

So I either need to break it out into multiple selects to filter the data, or loop at the it_main table and add in conditions to filter the data?

[nikolayevstigneev · Accepted solution]

It's one of the opportunities, but frankly speaking I don't get the idea of using outer (instead of inner) joins in this case. Let's have a look at the first two tables: kna1 and knvv. So, you want to select records from kna1 that fulfill certain conditions and records from knvv that fulfill some other conditions. Is it really the desired logic?

[nikolayevstigneev · Accepted solution]

Ah, I think I got it. You probably have some technical customers without specified sales organization and so on. And you want to include them in the report? Then yes, you'll have to rewrite your logic (maybe split into several selects). Unfortunately, I don't know the whole task, so it's for you to decide the exact way of solving it.

[Former Member · Accepted solution]

That is exactly it Nikolay. I am working on breaking it out, its just a little more involved than a single join would be. Thanks for the help.

Zach

[Former Member · Accepted solution]

I have a similar issue, but am using INNER JOIN...same error.

[former_member770121 · Accepted solution]

ITS IS NOT working still .