how to use Not Exist function

singhcv123 — Thu, 17 Mar 2016 11:49:02 GMT

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

Re: how to use Not Exist function

Chanty4u — Thu, 17 Mar 2016 17:04:24 GMT

what is all.booking?

use as [all.booking]

Chanty4u — Thu, 17 Mar 2016 17:06:46 GMT

and chk dis too