Im trying to delete from multiple tables using full outer join like this:

$del_id = (int) $del_id
DELETE contact, child, spouse FROM  contact FULL OUTER JOIN child ON child_name = c_name FULL OUTER JOIN spouse ON s_name = name WHERE contact_id = $del_id

I get warning/notice: unknown table contact in multi delete.

Why do I get this? My table is named correctly. Also if this is not the way to do it. Any guidance is much appreciated.

FULL OUTER JOIN is not supported by MySQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.