2 Replies Latest reply: Apr 3, 2012 2:38 PM by gerardo.pauza RSS

    join and where loading data

      Hi everyone,

            im trying to run a script with "left join" and "where" like this

       

      deal_externals:

      load

      xx,

      xx,

      xx,

      bac_id

      from deal_externals.qvd

      where bac_id is not null;

       

      left join

       

      deals:

      x,

      x,

      x

      from deals.qvd;

       

      But there is something wrong in the syntax with "where" condition:

       

      this is the error: Garbage after statement

       

      Could you help me to write the "where" condition in the right way.

       

      Thanks.