left join in mysql

left join in mysql


select email_address from nem_emails_tbl left join nem_send_tbl on email_id=send_emailid where email_id not in(select send_emailid from nem_send_tbl where send_letter=17)