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.

Re: delete multiple tables using full outer join 80 80

FULL OUTER JOIN is not supported by MySQL.

Be a part of the DaniWeb community

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