SELECT a~*,
b~*,
c~*
FROM zmmt8h AS a
INNER JOIN zmmt8i AS b ON a~msgid = b~msgid
INNER JOIN zwmst06 AS c ON a~msgid = c~msgid
WHERE a~msgid IN @s_msgid
AND a~rev_no IN @s_rsnum
AND c~msgtyp IN @lr_msgtyp
INTO TABLE @DATA(lt_zmmt8).
IF lt_zmmt038 IS NOT INITIAL.
SELECT a~umwrk,
a~lgort,
a~type,
a~zwl
FROM zmmt264a AS a
FOR ALL ENTRIES IN @lt_zmmt8
WHERE umwrk = @lt_zmmt038-a-umwrk
AND type = @lt_zmmt8-b-wafer
INTO TABLE @DATA(lt_zmmt2).
ENDIF.
inner join时可以将全部字段都查出来,lt_zmmt8中会形成 A B C三个组件,通过lt_zmmt8-b-wafer指定到具体的字段