At 14:40 -0400 on 06/07/2004, Jack Tanner wrote about "not unique table/alias":
I have two complex subqueries that I need to join. I suspect this
problem is due to using aliases instead of table names, but I don't
know how to work around it (temporary tables?). Please help.
SELECT col FROM (subquer
At 19:22 +0200 10/22/02, Ciprian I. Acatrinei wrote:
Hi,
mysql> INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1
FROM f_baldai_seq LIMIT 1;
ERROR 1066: Not unique table/alias: 'f_baldai_seq'
Please help.
It's like it says in the manual: you cannot insert into the same
table that y
Hi,
I think that when you use a table for one operation pe select or insert,
the table is locked and you cannot execute another operation.
In your statement if you use different tables for the two operations, I
don't think you'll have a problem...
Ciprian I. Acatrinei wrote:
Hi,
mysql> INSERT
Check out the 2nd bullet under 7.21.1 of the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT_SELECT
You could do this by creating a temporary table out of MaterialSubwall and
using that to select rows for the insert.
- TIM
> What does this mean? It is re
