6 Replies Latest reply: May 30, 2016 7:16 AM by Giorgio Taurisano RSS

    Join

    Giorgio Taurisano

      Hy,

       

      i have a problem with a 'inner join' from two table,

      my script looks like this:

       

      LOAD * ;

      SQL SELECT *

      FROM PANTH01.THIP.ORD_SRV

      inner join (ORD_SVR_ATV) SELECT * FROM PANTH01.THIP.ORD_SRV_ATV

      ON (ORD_SRV.ID_AZIENDA = ORD_SRV_ATV.ID_AZIENDA)

      AND (ORD_SRV.N_AZIENDA = ORD_SRV_ATV.N_AZIENDA);