I've encountered a problem: a query that I can perform on the mysql command-line cannot be performed using DBI. This is the query:

create temporary table foo as select id as id, 
person as person from mytable in (select id from person)
[download]

If I rewrite the query, it works:

create temporary table foo as select mytable.id as id,
mytable.person as person from mytable, person where 
mytable.person=person.id
[download]

Although I have found a workaround, I am curious why this would cause problems. The error seems to be in the subquery: "You have an error in your SQL syntax...near 'select id from person)'".