Re: "not unique table/alias"

2004-06-12 Thread Robert A. Rosenberg
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.

"not unique table/alias"

2004-06-11 Thread Jack Tanner
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 (subquery-1) AS t1, (subquery-2) AS t2 JOIN t1 ON t2.col = t1.col; Not unique

Re: message from server: "Not unique table/alias: 'USER_ROLE'" ?

2003-03-11 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul DuBois wrote: At 12:50 +0530 3/11/03, Mufaddal Khumri wrote: What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt =

Re: message from server: "Not unique table/alias: 'USER_ROLE'" ?

2003-03-11 Thread Paul DuBois
At 12:50 +0530 3/11/03, Mufaddal Khumri wrote: What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt = con.prepareStatement("Select * From USER_ROLE, ROLE" + &

message from server: "Not unique table/alias: 'USER_ROLE'" ?

2003-03-11 Thread Mufaddal Khumri
What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt = con.prepareStatement("Select * From USER_ROLE, ROLE" + "WHERE USER_ROLE.USERID

Re: Not unique table/alias

2002-10-22 Thread Paul DuBois
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 t

Re: Not unique table/alias

2002-10-22 Thread Vaso Koutsonikola
ql> 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. Thank's. - Before posting, please check: http://www

Not unique table/alias

2002-10-22 Thread Ciprian I. Acatrinei
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. Thank's. - Before posting, ple

Re: Not unique table/alias

2001-05-08 Thread Tim
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

Not unique table/alias

2001-05-08 Thread Peter-Frank Spierenburg
What does this mean? It is referring to the following SQL statement: INSERT INTO MaterialSubwall SELECT subwallClassId, mirrorEW, rotation + 180, sizeX, sizeY, offsetS, offsetW, offsetN, offsetE FROMMaterialSubwall; AFAIK, this