Re: Multiple tables in delete statement on Mysql 3

[Augey Mikus]

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?

Augey


Jay Blanchard wrote:

>[snip]
>is a statement like this not supported on mysql 3 but is supported in 
>mysql 4?
>
>delete table1 from table1,table2 where table1.id = table2.id;
>[/snip]
>
>DELETE FROM tablename WHERE table1.id = table2.id
>
>You can only delete from one table at a time.
>
>
>  
>