2 Replies Latest reply: Mar 17, 2016 1:06 PM by Chanty 4u RSS

    how to use Not Exist function

    Virendra Chawra

      Hi ,

       

       

      I have one query regarding not exists ...........

       

      I have 2 tables and from there i want to filter some data and those IDs i want to use some where else in table..................

       

       

      Query is .......

      Table1:

      LOAD [guest id]

      resident booking,medium

      where  booking_source ='Email';

       

       

      Table 2:

       

      LOAD [guest id]

      resident all.booking

      where not exists ([guest id]);

       

      DROP TABLE Table1;

       

       

      Actually i want to get only those guest ids ..those do not have valid email................

       

      so as per my scenerio.....first iam getting guest ids  having email ....from booking,medium table and than quering in all .booking table.......

       

       

      finally i want to use the data from table2 to reference other table...........

       

       

      but not working please suggest