Hi,
You can use variable.
set @a:=0; --initialise
select @a:=tablename.id from tablename,someothertable where tablename.id =
someothertable.id; --load the variable "a"
delete from tablename where tablename.id=@a;
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: "Augey Mikus" <mikus@stripped>
To: "Jay Blanchard" <jay.blanchard@stripped>;
<mysql@stripped>
Sent: Thursday, May 09, 2002 6:04 PM
Subject: Re: Multiple tables in delete statement on Mysql 3
> 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.
> >
> >
> >
> >
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread108496@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
