Join query from table with multiple foreign keys to same table primary key...

select t1.OfficeName,t2.OfficeName from Contact t3 INNER JOIN Office t1 ON t1.OfficeId=t3.OfficeId INNER JOIN Office t2 ON t2.OfficeId=t3.CoOfficeId