Re: Query with temporary table

2003-11-14 Thread Victoria Reznichenko
"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

Query with temporary table

2003-11-12 Thread Jeff McKeon
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