SELECT - JOIN
Inner Join
" Inner Join von zwei Datenbanktabellen Z_MAIL und Z_TEXT
SELECT z~nr1 z~nr2 z~endda z~begda h~text z~id
INTO TABLE gt_itab
FROM z_mail AS z INNER JOIN z_text AS h
ON z~objid = h~objid
WHERE z~nr1
IN s_nr1
AND z~nr2
IN s_nr2
AND z~endda IN s_endda
AND z~begda IN s_begda
AND h~text
IN s_text
AND z~id
IN s_id.