Question on where exists

[SK111]

Hello Friends,

Appreciate your time! 

I am looking for the syntax for the below scenario, please correct me

A:

Load distinct fielda&'|'&fieldb as new_field

from table1

where count>3;

B:

Load fielda&'|'&fieldb as new_field

from table2

where exists(new_field,fielda&'|'&fieldb);

For some reason the table B is all empty with the where exists clause, can you please correct the above syntax?

appreciate it!

Thank you!

[rwunderlich]

Your syntax looks correct. I would debug by removing the where exists and examining the two new_field values to see if they match up. 

-Rob