14 Replies Latest reply: Sep 26, 2015 12:41 AM by CHRISTIANE LAPEYRE RSS

    What is the syntax for an outer join ?

    CHRISTIANE LAPEYRE

      Hello

       

      A question of beginner : how can i make an outer join for these 2 tables ?

       

      I tried to use the syntax

      join (tab1) LOAD * FROM filename.csv

       

      For each key (@CLE_Site), and each month, i want to have one table with all values.

       

      I also have a problem with the date format of both tables.

       

      Here is an exemple of dataset and qw.

       

      Thank you for your help.

       

      Marie-Claire