How can I tell which data object is pre-joined to each other?

[Robert]

Question: 

How can I tell which data object is pre-joined to each other?

[Robert · Accepted solution]

Solution:

You can go to "Data Sources" link on the lower left side of the "Reporting" section.

In the "Data Source" field, choose a data object.   In the below example, we choose the "Rate Plan" data object.

In this case, the "Rate Plan" object is pre-joined to the below objects.  You can use any data from the below data objects in your query.

Account

Amendments

Bill To

Default Payment Method

Parent Account

Product

Product Rate Plan

Sold To

Subscription

Subscription Version Amendment