I might have mistaken, but I did not find any exists operator to implement on a correlated subquery. I see only map-exists operator which could be performed on a column but not between 2 tables. Any help or document would be great.
If you select Map operation on a column, and search for exists, which returns a boolean, and apply it, you will get a new column with "true" or "false" values. You can then filter on "true" or "false" to do the equivalent of what you need.
Great point @mjoshi!
You would accomplish your goal through a combination of joining the 2 tables and then filtering them down to your subquery’s conditions. If no rows exist, you will see one row with “FNF” in each column.
Did that answer your question?