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.
That is not the correct syntax for an UPDATE+JOIN. Try the following (assuming it is what you want, updating the table customer):
UPDATE customer b JOIN received_customer n ON b.phonenumber = n.phonenumber SET b.followUpStatus= 'y' ;