Skip to Content
0
Former Member
Jun 05, 2009 at 08:47 AM

joining 3 tables

130 Views

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