 Fullname,
 Nickname,
 Nametagname,
+Secondary,
 Activenow,
 Udeptequiv,
 Uempltype,

re.id
     FROM masterlist AS ma, household AS ho, residence AS re
WHERE (ma.Last = ho.Lastname) and (ma.first = ho.Firstname)
AND   (re.HouseholdID = ho.id) AND re.Prisec = 'Pri' AND ma.telephone is not null AND ma.telephone != "";

/* 8. Link second Phone number as U of M office number to member in Person */
INSERT INTO phone (

CONCAT(ma.first, ' ', ma.Last),
`first`,
CONCAT(ma.first, ' ', ma.Last),
0,
1,
dept,
(CASE
