如何使用另一个表中的多个列替换表中的一列

I have a table that has two different references to an address table. I would like to replace each reference id with the actual columns in a view. I envision something like what follows, but that does not work. I am using MySQL 5.5. What is the correct grammar?I have a table that has two different reference