I have a table of addresses with both mailing and home addresses identified by a personid foreign key. I would like to create a home address for the the persons that do not already have one.
addressid (pk) personid(fk) addtype street zip . . . . . . .
1 1 home abc street
2 1 mailing xyz street
3 2 mailing 123 street