0

Hi i have a problem in Mysql, how can i resolve this. Im getting unknown table first_name in MULTI DELETE.

DELETE personal_info.first_name, personal_info.last_name,       
        contact_info.email_address, 
        contact_info.cellphone_number,address_info.city,address_info.province,
        address_info.country
FROM personal_info
    INNER JOIN contact_info ON personal_info.id =  contact_info.personal_info_id
    INNER JOIN address_info ON personal_info.id= address_info.personal_info_id
WHERE personal_info.id = "1";
RiggsFolly
  • 93,638
  • 21
  • 103
  • 149
Joy
  • 1
  • 1

0 Answers0