Hi ,
i want to join convert the following code into a select with join of 3 tables please help me
SELECT LL02LGNUM LL02LOBID
LL02TBNUM LL02TBPOS
LL02TBSTT LL02BWLVS
LL02STATU LL02EDATU
LL02EZEIT LTBPTAMEN
INTO (WA-LGNUM,WA-LOBID,WA-TBNUM,
WA-TBPOS,WA-TBSTT,WA-BWLVS,
WA-STATU,WA-EDATU,WA-EZEIT,
HLP_TAMEN)
FROM LL02 JOIN LTBP
ON LTBPLGNUM = LL02LGNUM AND
LTBPTBNUM = LL02TBNUM AND
LTBPTBPOS = LL02TBPOS
WHERE LL02~LGNUM = P_LGNUM
AND LL02~BWLVS IN S_BWLVS
AND LL02~VLTYP IN S_VLTYP
AND LL02~NLTYP IN S_NLTYP
AND LTBP~ELIKZ = ' '.
SELECT SINGLE *
FROM LTBK
WHERE LGNUM = WA-LGNUM
AND TBNUM = WA-TBNUM
AND ( STATU = ' ' OR STATU = 'T' )
AND BDATU < G_CUTOFF_DATE.
endselect