INSERT INTO Registration (FirstName, CreatedOn, LastUpdated, DefaultPicture, Pwd, UserName, SiteID, Comment, Deleted, PersonType, CellPhone, HomePhone, ScreenName, Email, State, Zip, City, Address2, Address1, Gender, LastName, MiddleName, DOB, Grade, School, Medications, DietRestrictions, Allergies, CurrentPoints, TotalPoints, MitzvahRewardsID, MedicalConcerns,, NonActivities, LTetnus, TylenolAllowed, AspirinAllowed, MedicalInsurance, PolicyNum, EmergencyContact, RelationshipContact, EmergencyContactPhone, Physician, PhysicianPhone, Hospital, ToiletTrained, Pets, TherapiesDetails, NamesAgesSiblings, ChildDescription, ChildsCommunicationSkills, FavActivities, LFavActivities, GainFromFC, HeardAboutFC, WantFriendAtHome, Interviewed, PublishPictures) SELECT People.FirstName, People.CreatedOn, People.LastUpdated, People.DefaultPicture, People.Pwd, People.UserName, People.SiteID, People.Comment, People.Deleted, People.PersonType, People.CellPhone, People.HomePhone, People.ScreenName, People.Email, People.State, People.Zip, People.City, People.Address2, People.Address1, People.Gender, People.LastName, People.MiddleName, People.DOB, Volunteers.Grade, Volunteers.School, Volunteers.Medications, Volunteers.DietRestrictions, Volunteers.Allergies, Volunteers.CurrentPoints, Volunteers.TotalPoints, Volunteers.MitzvahRewardsID, Friends.MedicalConcerns, Friends.Medications AS Expr1, Friends.NonActivities, Friends.LTetnus, Friends.TylenolAllowed, Friends.AspirinAllowed, Friends.MedicalInsurance, Friends.PolicyNum, Friends.EmergencyContact, Friends.RelationshipContact, Friends.EmergencyContactPhone, Friends.Physician, Friends.PhysicianPhone, Friends.Hospital, Friends.ToiletTrained, Friends.Pets, Friends.TherapiesDetails, Friends.NamesAgesSiblings, Friends.ChildDescription, Friends.ChildsCommunicationSkills, Friends.FavActivities, Friends.LFavActivities, Friends.GainFromFC, Friends.HeardAboutFC, Friends.WantFriendAtHome, Friends.Interviewed, Friends.PublishPictures FROM People INNER JOIN Volunteers ON People.PersonID = Volunteers.PersonID INNER JOIN Friends ON People.PersonID = Friends.FriendID