left outer join issue in select

[former_member196080]

Hi Experts

I'm trying to write code for datasource enhancement and using select with left outer join.

But issue is there is record in left table with id equal to "X" and not in write table my select is not picking up the record. As part of this I need to pick the record in main table even if no entries in write table. Not sure whats the issue here,posting code below

SELECT *  INTO CORRESPONDING FIELDS OF

     TABLE ITAB

   FROM  main table  AS m left outer join second table AS s ON

       m~id = s~id  where m~inum NE ''.

Please help if you could.

Thanks

[Jelena_Perfiljeva]

Unable to understand the post. What is "write" table? Could you just explain using the same names as in SELECT? What values do you have in the database? And what exactly is the question?

Overall JOIN is a rather straightforward SQL command and is explained in ABAP documentation.

[former_member196080]

I think its resolved I was doing reading * which was causing not to read from either tables.

Also another question I've is I'm creating datasource at infoset and for reading few fields on few conditions I'm doing left outer join on the same two tables where I've infoset biuld.

Is that right approach?

Thanks

[Sandra_Rossi]

First, let me correct it : SELECT * works perfectly with an outer join (or there is a bug in the SAP "kernel" but I doubt). You probably have an issue in your whole program.

I don't understand your new question, anyway you should open a new thread, and close this one.

[retired_member]

Check the documentation SELECT - JOIN and the examples given there ...