Skip to Content
0
Jul 24, 2020 at 01:23 PM

left join between two tables

107 Views

to get only the data from the left table I have to use a right left join?

this is the code:

select *

from marc

left outer join mseg on marc ~ matnr = mseg ~ matnr and marc ~ werks = mseg ~ werks

into CORRESPONDING FIELDS OF TABLE it_marc

WHERE marc ~ WERKS in s_plant and mseg ~ CPUTM_MKPF> = sy-uzeit. .

gives me this error:

If new Open SQL syntax is used, all host variables must be escaped using @. The variable S_PLANT is not escaped.