I have table A with a field called emails I need to check table B that also has a field called emails. If an email in table A does not show in table B I need to do something.
Here is the sql part I have so far
$check=$this->db->query("SELECT * FROM default_appointment WHERE email NOT IN (SELECT email FROM default_consultation)");
I am not sure if I am on the right track and if I am I am not sure how to implement the php portion. How would I go about doing this?</div