TEMPORARY table in SELECT 1

[bobo123]

I have problems with using temporary table in SELECTs, where is tmptable JOINed more then once.
F.e.:
CREATE TEMPORARY table tmptbl SELECT * from basetable
Next is O.K.:
select * from table1
left join tmptbl tmp1 on table1.a1=tmp1.a
order by ...
Next gives me an error:
select * from table1
left join tmptbl tmp1 on table1.a1=tmp1.a
left join tmptbl tmp2 on table1.a2=tmp2.a
order by ...

With standard (non temporary table) are BOTH examples OK.

Please any experience, contribution ??
Thanks a lot
Nikos
nikosx@email.cz

 

[piti]

well, this won't work m8

from the mysql documentation:

Known Errors and Design Deficiencies in MySQL (

http://www.mysql.com/doc/en/Bugs.html)

You can't use temporary tables more than once in the same query. For example, the following doesn't work:
mysql> SELECT * FROM temporary_table, temporary_table AS t2;

 

[bobo123]

Thanks a lot,
that's what I was looking for !
Bobo