I have some tables where I am getting the emails. And I don't want to get the emails in table tbl_unsubscribe
. I wrote the query like :
SELECT cand_email FROM tbl_cand_data
UNION
SELECT emp_email FROM tbl_emp_data
UNION
SELECT email FROM tbl_uptade_list
UNION
SELECT feed_email FROM tbl_feedback
UNION
SELECT admin_email FROM tbl_admin_emails
But I am getting a syntax error. Is the MINUS
operator not valid for MySQL ?