Hi,

I have 3 objects

1. Case
2. Risk Profile
3. Investment option.

Case and Investment option has a look up field to Risk Profile.

I am trying to write a query to include details from the case, related risk profile and all the child investment options to the given risk profile.

So far I am able get the information in 2 separate queries, haven't found much luck in combining them togather.

Query 1. Select name, (SELECT name FROM investment_options__r) From Risk_Profile__c
Query 2. Select name, (SELECT name FROM Cases) From Risk_Profile__c

Any Help is appreciated.

Thanks

Talal

 

Hi,

I have 3 objects

1. Case
2. Risk Profile
3. Investment option.

Case and Investment option has a look up field to Risk Profile.

I am trying to write a query to include details from the case, related risk profile and all the child investment options to the given risk profile.

So far I am able get the information in 2 separate queries, haven't found much luck in combining them togather.

Query 1. Select name, (SELECT name FROM investment_options__r) From Risk_Profile__c
Query 2. Select name, (SELECT name FROM Cases) From Risk_Profile__c

Any Help is appreciated.

Thanks

Talal