Skip to Content
0
Former Member
Mar 04, 2009 at 05:22 PM

Inner join 3 tables

1935 Views

Hi guys,

I would like to join 3 tables so my code is:

SELECT IFLS_ADDR~TPLNR  IFLS_ADDR~PLTXT
       ZDRMIFLOT001~QMNUM QMEL~QMTXT QMEL~ZZPOTSOL QMEL~OBJNR
INTO CORRESPONDING FIELDS OF TABLE IT_ALV  FROM
ZDRMIFLOT001 INNER JOIN IFLS_ADDR
          ON ZDRMIFLOT001~TPLNR = IFLS_ADDR~TPLNR
          INNER JOIN QMEL
          *ON QMEL~QMNUM = ZDRMIFLOT001~QMNUM*
WHERE IFLS_ADDR~TPLNR IN S_TPLNR
     AND   IFLS_ADDR~FLTYP IN TIPO
     AND   IFLS_ADDR~POST_CODE1 IN P_CODE1
     AND   IFLS_ADDR~CITY1 IN P_CITY1
     AND   IFLS_ADDR~STREET IN P_STREET.

The problem is:

if field QMNUM is empty the inner join doesn't work well I loose information because even though

QMNUM is empty I would like to inform the other fields of it_alv.

Thanks a lot.