8 Replies Latest reply: Mar 15, 2017 7:18 AM by Zied Ahmed RSS

    field not found in statement where not exists

    Zied Ahmed

      Hello,

      I have a problem...

      I have two tables :

      first named tmp :

      tmp:

      load *;

      SELECT ,

        Field1

       

      FROM table1

       

      [Doc]:

      LOAD

        

      Field1

        resident tmp;

        drop table tmp;

       

       

      the second tmp_targa:

      tmp_targa:

      LOAD chart

      ;

      SELECT CHART

      FROM Table2

       

      i would like to use Where not Exists between the two table like :

       

      final:

      load*,

       

      Where not Exists(CHART);

       

      But I have a problem that the field chart is not found

      what is the problem ?