i have 2 table such as company and companyrelationship.
2nd table have the following fields.
id ,subject,relationship type,company object.


I need to write a query which joins companyrelationship with company so that, I can see: "Subject is a [relation] of object" for each record

I am having a hard time understanding how to join to "company" twice, once to get the company name of "subject" and once to get the company name of "object"

Any pointers?