"Jeff McKeon" <[EMAIL PROTECTED]> 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
Is is possible to do a select query with a left join from a real table
to a temporary table? I'm trying it but keep getting "unkown table
'tablename' in field list" error.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com