I need to compare two fields and mark the similar fields in third table.
Tables customer: phone id, phonenumber followstatus received_Customer: rc_id, rc_phonenumber.
I need to mark the
n/a in follow up which is in received and customer table.
update customer select b.phonenumber from received_customer n join customer b on b.phonenumber = n.phonenumber SET followUpStatus= 'y' ;
I run query in php.