Re: "not unique table/alias"

[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.
SELECT col FROM (subquery-1) AS t1, (subquery-2) AS t2
JOIN t1 ON t2.col = t1.col;
Not unique table/alias: 't1'.
SELECT col FROM (subquery-1) AS t1, (subquery-2) AS t2
WHERE t2.col = t1.col;
Works fine! (But this query is different, because it doesn't get
the rows that are NULL in one of the tables.)
Using MySQL 4.1.2. Thanks in advance for your help.
I think it is screaming about a syntax error since you do not have 
two tables for the Join. Try:

SELECT col FROM (subquery-1) AS t1
JOIN (subquery-2) AS t2
ON t2.col = t1.col;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]