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
0
votes
0answers
23 views

Salesforce Einstein Dataflow Join

In the dataflow, Is it possible to merge two tables based on the same key in which one table has multiple values? (See attached image) Site Code is the key between the two tables.
2
votes
1answer
274 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
18 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
47 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
742 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
422 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 ...
0
votes
1answer
96 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
183 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
842 views

SOQL Joins compared to SQL Joins [closed]

What are the key differences between SOQL Joins and SQL Joins?
0
votes
1answer
202 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
286 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
111 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
395 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
238 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 ...