Skip to Content
0
Aug 10, 2016 at 04:06 PM

left outer join issue in select

52 Views

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