You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Join same table twice

edited Jul 18, 2016 6:07PM in Reporting & Analytics for B2C Service 1 comment

Content

We have a table called Relationship contain two Contact Ids (SubjectContact and ObjectContact).

I have to create a report to display the contact names for both Id's.

I can join contact table with Relationship object(Contact.Id = Relationship.SubjectContact) and get contact full name. How can I create a Contact join again with Relationship.ObjectContact to get the full name of Object Contact.

 

Any help is greatly apprecaited.

 

 

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!