i have two tables. i’m trying to construct a case statement that flags if the values in table 1 are not in the values in table 2.

case when lower(last_name_part2) not in (select lower(last_name) from scratch.white_surnames) then 1 else 0 end as nonwhite_names

but snowflake says ‘Unsupported subquery type cannot be evaluated’

This method works for “in” but not “not in.” what is the proper syntax for doing this case statement in snowflake or is it just not possible? is there another way?

thanks

i tried “not in” but got the “unsupported” error