Aha, much appreciated...your words "therefore the target table may not
appear in the SELECT clause" have made it clear to me...but can I assume
that if I was to use aliases, then I would be able to sneak past this
problem? :)
John :^)
Benjamin Pflugmann wrote:
> Hi.
>
> As is described so
Hi.
On Tue, Oct 02, 2001 at 03:53:12PM +1000, [EMAIL PROTECTED] wrote:
> Aha, much appreciated...your words "therefore the target table may not
> appear in the SELECT clause" have made it clear to me...but can I assume
> that if I was to use aliases, then I would be able to sneak past this
> prob
Hi.
As is described somewhere (http://www.mysql.com/doc/R/E/REPLACE.html),
REPLACE mainly behaves like INSERT and therefore the target table may
not appear in the SELECT clause (as described here:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html).
Sorry, but it seems you have to use a temporary t
.id;
> -Original Message-
> From: John Mravnuac [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 8:28 PM
> To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Subject: HELP PLEASE - C API code help: UPDATE query using result from
>
SELECT
>
>
essage-
> From: John Mravnuac [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 8:28 PM
> To: [EMAIL PROTECTED]
> Subject: HELP PLEASE - C API code help: UPDATE query using result from
> SELECT
>
>
> Hi,
>
> I believe that the query below is correct,
Hi,
I believe that the query below is correct, but I do not believe that it is
possible in MySQL currently due to it not supporting sub-selects:
UPDATE table1 SET ID=table2.ID, Company=table2.Company,
Modified=table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company WHER