I think that there is an error in your syntax

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

should be

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