http://stackoverflow.com/questions/10594140/select-multiple-columns-from-a-row-that-are-based-on-same-related-table

Also this,

http://stackoverflow.com/questions/9114781/join-multiple-columns-from-one-table-to-single-column-from-another-table