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.