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
