On Nov 29, 2007 11:17 PM, Robert Cummings <[EMAIL PROTECTED]> wrote:
> On Fri, 2007-11-30 at 14:00 +1100, Chris wrote:
> > > Out of curiosity, what SQL server (and version) are you using? I
> > > currently have MySQL 5.0.33 on my dev box and I had no problem with the
> > > query I gave you. Perhaps it's a version issue. There really shouldn't
> > > be a problem updating a table that also occurs in the select query since
> > > the select query should take place before the insert.
> >
> > He wasn't doing an insert/select, he was doing an update with two tables
> > joined together.
>
> He was doing an update/select and an insert/select. And the query I sent
> performed the insert/select without problem on my system. A similar
> query would have done the update/select. The fact that the select
> portion required a join doesn't change anything.
>
> > <copy>
> >
> > I thought that --
> >
> > UPDATE user1 u1, user2 u2
> > SET u1.login = u2.login, u1.password = u2.password
> > WHERE u1.username = u2.username
> >
> > -- would work, but it don't.
>
> Wrong query for either of the needs :)
>
> Cheers,
> Rob.
> --
> ...........................................................
> SwarmBuy.com - http://www.swarmbuy.com
>
> Leveraging the buying power of the masses!
> ...........................................................
>
> --
>
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Rob,
The version difference is probably right on the nose. If I
remember correctly, you couldn't do that in the long-popular 3.23,
which *gasp!* is still used by some web hosts, believe it or not.
--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
If at first you don't succeed, stick to what you know best so that you
can make enough money to pay someone else to do it for you.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
