Select Code to Download

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

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