Join über 2 Tabellen

Code: Alles auswählen.

SELECT           kna1~kunnr as kunnr
     INTO        CORRESPONDING FIELDS OF TABLE ITDATA
     FROM        KNA1         AS   KNA1
     WHERE       KNA1~KUNNR   IN   S_KUNNR
     AND
     (   NOT EXISTS
         ( SELECT   MANDT
             FROM   KNB1 AS KNB1_NOTEXISTS
             CLIENT SPECIFIED
             WHERE  KNB1_NOTEXISTS~MANDT   EQ   KNA1~MANDT
               AND  KNB1_NOTEXISTS~KUNNR   EQ   KNA1~KUNNR
         )
       or
         EXISTS
         ( SELECT   MANDT
             FROM   KNB1 AS KNB1_VALUE
             CLIENT SPECIFIED
             WHERE  KNB1_VALUE~MANDT   EQ   KNA1~MANDT
               AND  KNB1_VALUE~KUNNR   EQ   KNA1~KUNNR
*              * hier speziellen Wert angeben
               AND  KNB1_VALUE~BUKRS   EQ   '    '
         )
     )
      .   "end of select