dazormiq

Putting the insert into in front did it. Thanks for helping this newbie out.

How can I convert the following sql code to working mysql? SELECT Employees.Email AS employee_email, Job_Titles.Supervisor AS Supervisor_Title INTO Supervisors_temp FROM Job_Titles INNER JOIN Employees ON Job_Titles.Job_Title_ID = Employees.Job_title_ID; I keep getting "Undeclared variable: Supervisors_temp". The table exists and gets truncated before the data is put into it. Currently these tables are stored in an access database being edited through a coldfusion page. I would love to move to mysql just for the performance boost.