I have a simple query where I want to see how many records were not added in DE. But with below query I am getting error "Errors: An expression of non-boolean type specified in a context where a condition is expected"
select
q.email_address, q.uuid
from usca_restaurant_contact_v3 q
where (q.email_address, q.uuid) not in
(select p.email_address, p.uuid from usca_restaurant_contact_v3_chkng_pk p)
Any other way to do this? I am trying to see how many records from usca_restaurant_contact_v3 were not added into usca_restaurant_contact_v3_chkng_pk?