i am trying a query like
select email from table_1 where email not in (select email from
for some reason, i am getting (at least one) email rows returned which
also appear in table_2 ...
i have tried using LOWER(email) for both selects, thought the email i
am getting is all lowercase in both tables.
my goal is to only return emails that appear in table_1 but not if they
also appear in table_2.
is there some way to handle this with LIKE or am i missing something in
that these are 'chars' (could the in emails be causing ...