14 Replies Latest reply: Sep 26, 2015 12:41 AM by Christiane Lapeyre RSS

    What is the syntax for an outer join ?

    Christiane Lapeyre



      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.