RE: Multiple tables in delete statement on Mysql 3

[Jay Blanchard]

[snip]
if i say:

delete from tablename where tablename.id = someothertable.id;

mysql complains because there is no reference to someothertable;
error: Unknown table 'someothertable' in where clause.

So how can I reference both tables without deleting from both tables?
>
>DELETE FROM tablename WHERE table1.id = table2.id
>
[/snip]

You can try (i haven't tested this) the following, but I don't think it's
going to work;

DELETE table1.columnname FROM table1, table2 WHERE table1.id = table2.id

You would have to cycle through all of the columnnames if it worked.

Jay