TalkPHP - View Single Post

serversphere · 04-03-2008, 01:08 PM

No idea if this will work (not sure you can actually run a join query against a table that is being edited) but try this:

Code:

DELETE FROM contact AS c, ca
LEFT JOIN contact_additional AS ca 
ON c.ticket=ca.ticket
WHERE c.ticket='MM1234.1234'

04-03-2008, 01:08 PM	#3 (permalink)
serversphere The Wanderer Join Date: Dec 2006 Location: USA Posts: 21 Thanks: 0	No idea if this will work (not sure you can actually run a join query against a table that is being edited) but try this: Code: DELETE FROM contact AS c, ca LEFT JOIN contact_additional AS ca ON c.ticket=ca.ticket WHERE c.ticket='MM1234.1234'