Hi, I have to port an SQL expression like
DELETE FROM TableA FROM TableB WHERE TableA.ID = TableB.IDA AND TableB.IDB=42 from another SQL dialect to MySQL. The twice "FROM" is no mistake, it's done to declare "TableB" for the WHERE expression. In (some) other SQL dialects this is possible/legal. The alternative with a sub-query like DELETE FROM TableA WHERE TableA.ID IN (SELECT TableB.IDA FROM TableB WHERE TableB.IDB=42) isn't possible with MySQL, too (no sub-queries possible). Any ideas how to solve the problem? Thanks in advance for any information. Regards Martin Schlöter --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
