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.