Question on where exists

SK111 — Thu, 05 Oct 2023 19:54:04 GMT

Hello Friends,

Appreciate your time!

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

Load distinct fielda&'|'&fieldb as new_field

from table1

where count>3;

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!

Re: Question on where exists

rwunderlich — Fri, 06 Oct 2023 08:34:16 GMT

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