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

##</code><code>##

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