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";