Member Avatar for nadiam

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.

Edited by pritaeas because: Fixed markdown.
  • 1 Contributor
  • 1 Reply
  • 195 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by nadiam
Member Avatar for nadiam

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.