select p.number, p.user, p.first, p.lastn, t.tel, e.email
from      people    p
left join telephone t on t.number = p.number
left join email     e on e.number = p.number