Joins in sql
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?
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?
-
KirkMcD -
Thanks
{{ DiscussionBoard.errors[10636871].message }} -