Create table fooTable asselect a.key, a.first, a.last, b.street, b.zipfrom aTable a,anotherTable bwherea.key = b.keyand a.other = b.other
And now you can move your database data around with ease. I know that many of you probably already knew all of this, but hey...I thought it was cool.
insert into fooTable a (
a.key, a.first, a.last, b.street, b.zip)
select b.key, b.first, b.last, c.street, c.zip
from aTable b,
where a.key = b.key
and a.other = b.other