select
m.messageid,
m.message,
m.orig,
m.recip,
d.company as orig_company,
d.department as orig_department,
d.office as orig_office,
d.country as orig_country
from department d
join messages m
on m.originator = d.address

select
m.messageid,
m.message,
m.orig,
m.recip,
d.company as recip_company,
d.department as recip_department,
d.office as recip_office,
d.country as recip_country
from department d
join messages m
on m.recip = d.address