From: Victoria Reznichenko (victoria.reznichenkoensita.net)
Date: Fri Nov 14 2003 - 04:33:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

"Jeff McKeon" <jmckeontelaurus.com> wrote:
> Is is possible to do a select query with a left join from a real table
> to a temporary table?

Yes.

> I'm trying it but keep getting "unkown table
> 'tablename' in field list" error.

Show us you query.
Don't forget that temporary table is visible only for the current connection.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]