How to Join these tables?

Thu, 20 Sep 2012 03:13:02 GMT

I Want to join 4 tables 1st table:sales, 2nd:Partners, 3rd:Quarter,4th:Week. The relation between the tables is as follows:

Sales is having lookup relationShip with Quarter and Partner

Week is havig lookup relationship with Quarter.

(Fields in the table: Quarter--->Quarter__c,Quarter end date,Quarter Start date

Week--->Week name,WeekEnd date,WeekStart date,Quarter__c

Sales--->Quarter__c,Sales,Partner__c

partner--->Partner__c,Createddate)

Note:Every partner will have at least one transaction in Sales.

I need to display as following:

Quarter Week Sum(Sales) count(Partner)

Q2 Week01 200 10

Q3 Week02 300 25

Q4 Week03 500 40

I need to prepare the report by today. Any ideas please?

Re: How to Join these tables?

deepakk — Thu, 20 Sep 2012 06:07:21 GMT

Hi,

Load *,Quarter__c ,Partner__c from Sales;

join

Load *,Partner__c from Partner;

join

Load *,Quarter__c from Quarter;

join

Load * ,Quarter__c from Week;

I hope this helps.

Deepak