Hola, tengo el siguiente query pero me marca ese error:
Código:
SELECT t1.email_id,t2.email_addr from em_list_have_mail as t1,em_user_emails as t2
where
t1.email_id not in
(SELECT t1.email_id,t2.email_addr from em_list_have_mail as t1,em_user_emails as t2
where
t1.email_list_id=11 and t1.email_id=t2.email_id and t2.created_by=1)
por no entiendo