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 table to store the
intermediate result.
Bye,
Benjamin.
On Tue, Oct 02, 2001 at 12:39:18PM +1000, [EMAIL PROTECTED] wrote:
> Hi,
>
> When I try and use the REPLACE function such as:
>
> REPLACE INTO table1 SELECT table2.ID, table2.Modified FROM table1 INNER JOIN table2
>ON table1.Company=table2.Company;
>
> I get:
>
> ERROR 1066: Not unique table/alias: 'table1'
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
