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?