Questions tagged [outer-join]

Outer join is type of join in which co-existing subset + other records are returned

Filter by
Sorted by
Tagged with
2
votes
1answer
666 views

SOQL join in a Parent Child for same table (Account)

I want to write this simple soql query where in Account there is a ParentId and with it would want to bring the name of this parent (Hierarchy field) Something like: select Id, Name, (select Name ...
0
votes
1answer
34 views

Is it possible to query the chattergoup where the current user is in in one query

I am trying to get the group where the current user is in. In this case the user can only be member of one group. I tried the following but the I would have to loop trough the CollaborationGroup ...
0
votes
2answers
61 views

Combining SOQL Queries

I need to pull out a query that fetches: From My Team object and Package object. Package is a child of Teams From teams I need to pull how many packages is currently in teams and how much each ...
2
votes
1answer
2k views

How to access child records from an inner query in apex [duplicate]

I have a piece of code in my Apex: List<sObject> assessmentToQuestions = [ SELECT Id, (SELECT Id FROM zced__Assessment_Questions__r) questions FROM zced__Assessment__c ...
6
votes
1answer
564 views

Complicated SOQL SELECT

I have the following data model: Now I would like to do the following: By knowing zced__Interaction__c extract all the zced__Assessment__c. Then for each of the extracted zced__Assessment__c I would ...
0
votes
1answer
125 views

How to find duplicate records for master record

I have 3 (A,B,C) objects they are A-master B-Junction object and C master of B object, B object has the Master detail relationship with A and B objects. When the records created for B due to some ...
1
vote
2answers
241 views

SOQL: Left join Contact fields to custom object

So i have a custom object which has in of one of the fields( Creator__c ) the Id of the person who created it which is also the Contact Id, and i'm trying to get the contacts first and last name field ...
0
votes
1answer
2k views

SOQL Joins compared to SQL Joins [closed]

What are the key differences between SOQL Joins and SQL Joins?
0
votes
1answer
223 views

Join salesforce objects with AMPscript within the same email

I want to create a transactional email for orders, containing data about the consumer (Account object), data about his order (Order object) and data about the ordered products (products object). The ...
2
votes
2answers
436 views

SOQL performance of joins

Considering the following scenario: Objects: Child__c, Parent1__c, Parent2__c Relationships: Child__c - Parent1__c (Lookup) Child__c - Parent2__c (Master-detail) I want to query for Parent1 and ...
0
votes
2answers
157 views

SOQL join or relation query

I have 2 tables Deal__c and DealProduct__c. They have one to many relation. I want to combine 2 SOQL queries with different where clause: Select Name, Date_Of_Deal__c, Total_Amount__c from Deal__c ...
5
votes
2answers
494 views

Convert SQL query into SOQL query

I've been trying to figure out how to turn this SQL query into a SOQL query. Every time I think I am getting better with SOQL something comes along and erases that thought. Account is the parent ...
2
votes
1answer
327 views

Best approach for creating Junction object with millions of records

I have two objects Object1 and Object2 in Salesforce. These two objects doesn't have Master-Detail relationship. But they are related through a Text column X. I want to create many to many junction ...
6
votes
2answers
2k views

SOQL Outer Join Multi Level Master Detail Relationship

I am working with a 3 Level Master Detail Object Relationship: "Level 1" has "Level 2" detail records "Level 2" has "Level 3" detail records I am trying to Query "Level 1 records" and using an ...