Questions tagged [inner-join]
The inner-join tag has no usage guidance.
42
questions
0
votes
1
answer
54
views
Query Returning Duplicates
Goal:
Query all emails sent for particular emails with the contact information and bounce information for each.
Issue:
Query results contain duplicate records.
Question:
How can I modify the query so ...
- 25
2
votes
1
answer
175
views
What are the objects/entities that are NOT allowed in an inner join SOQL query?
I've tried to do an inner join SOQL query using Events/Tasks:
SELECT Id FROM Attachment WHERE ParentId IN (SELECT Id FROM Event) LIMIT 1000
But I failed with the error:
"Entity 'Event' is not ...
- 35
1
vote
1
answer
561
views
Fetching records where the field value is null or similar to SOQL inner query
There is a sObject called Promo_Association__c which have a lookup field(Partnership__c) on Account object. There is a quick action on Opportunity layout and the requirement is to fetch Promo ...
-1
votes
1
answer
2k
views
How to query two unrelated objects? [duplicate]
I want to query two unrelated objects, and I can't create a lookup relationship between them.
They have the same global picklist sets in both of them and I want to query the records from one of the ...
- 1
0
votes
1
answer
2k
views
How to join/cogroup by multiple fields in SAQL?
I am new to SAQL and am trying to join two datasets (let's call them q and r) using cogroup. I have 4 columns in each table (let's call these A, B, C and D). Columns A - C are the same in both ...
- 1
0
votes
1
answer
139
views
Get a one to many database output in one column in a one to one database Salesforce Marketing Cloud
We have a one to many table where we store all our transactions and a table where we store all the seperate items they bought. So it looks like:
| **TABLE ONE** | | **TABLE TWO** |
| ...
- 5
0
votes
2
answers
260
views
Get all PDFs from all Quotes from an Opportunity - Apex Inner Join?
I have the following feature request:
On the opportunity level I want to see all pdfs from all quotes from that very opportunity. So I think (hopefully) this is something Apex can do for me.
As I am ...
- 87
0
votes
1
answer
751
views
SOQL `JOIN` by relationship
I have two queries as follows: Is there a way to JOIN them in one query using the Question__r.Id?
(I know SOQL doesn't have JOINs, but maybe an alternative solution?)
List<Answer__c> l= [...
- 385
1
vote
1
answer
135
views
How to modify semi-join and anti-joins
I have similar code to this where I want to store the values of a query from a semi-join and anti-join. I want to store the values in a list respective on whether if its a semi-join or anti-join. But ...
- 11
2
votes
1
answer
173
views
How to structure a multi object query
I have been stuck on this for a couple of days now and have scoured the internet for examples. No luck yet!
I have a question about how to structure a query that will return the data that is ...
- 135
0
votes
1
answer
105
views
Contacts and Orders Join - Primary Key Violation
I'm trying to pull in a list of contacts who've ordered within the last 2 days into a separate DE with the contact ID as the Primary Key. However, I've tried several SQL Join queries in Marketing ...
0
votes
2
answers
451
views
How can i combine my variable to with soql command
Hello friends firstly i get field data in contact object and after i start the loop till OwnerId and after i want to combine with my soql command i took error message
Error Message: Unexpected token '...
-1
votes
2
answers
338
views
I want to write inner join in SOQL i was search but i couldnt found and my thought its a big problem
I try this code its was send this message i couldnt found well answer
Note: I want to make innerJoin Account to Contact like this,
And i am sure already each other have a releationship
Select ...
0
votes
1
answer
328
views
SQL Join Within Same Data Extension, Surveys
I made a survey in the Sales Cloud that I am pulling into the Marketing Cloud using automation studio and the responses are saved in a data extension. However every question response appears as a ...
- 149
1
vote
2
answers
1k
views
How do I use this column in a SOQL join?
I'm trying to write a JOIN in SOQL. But having some problems. I have a column
PLWorkshopProduct__c
in my table that links to another table, Product2. I tried writing the below ..
Select ID FROM ...
- 87
0
votes
1
answer
127
views
Report to show duplicate cases created in 48 hours
I want to create a reports to show only duplicate cases (With same type and sub type) which is created within 48 hrs
- 3
2
votes
1
answer
2k
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 ...
3
votes
1
answer
9k
views
SOQL Query Inner Join
Could you please help me with the syntaxis of this SOQL Query? I would like to do an INNER JOIN between A and B on A.FamilyMember=B.ID
SELECT A.FamilyMember__c
FROM A
WHERE A.StartDate__c > TODAY ...
- 1,039
1
vote
4
answers
2k
views
How does class Map work?
I trying to learn Triggers from TrailHead, but not able to understand this line of code.
Map<Id,Account> acctsWithOpps = new Map<Id,Account>(
[SELECT Id,(SELECT Id FROM Opportunities) ...
- 25
0
votes
3
answers
2k
views
How do i join ContentDocumentLink with Account with SOQL query?
I want to find a file(ContentDocument) which is associated with a particular account with SOQL. I have tried below query.
Select LinkedEntityId,ContentDocumentId from ContentDocumentLink where ...
- 103
0
votes
1
answer
643
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
...
- 2,294
0
votes
2
answers
245
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 ...
- 53
2
votes
1
answer
9k
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
...
- 1,105
6
votes
1
answer
922
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 ...
- 1,105
7
votes
2
answers
4k
views
Entity 'Task' is not supported for semi join inner selects
I want add a default task to an opportunity when this one is close won and the opportunity hasn't any task.
I get the error compiling the below code:
Entity 'Task' is not supported for semi join ...
- 71
0
votes
1
answer
310
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 ...
- 197
0
votes
1
answer
148
views
SalesForce How to Join Works?
My SQL Query for Join
SELECT LoginIp.SourceIp, LoginHistory.SourceIp
FROM ( LoginHistory INNER JOIN LoginIp ON LoginHistory.SourceIp = LoginIp.SourceIp)
To get Source Ip from LoginIp table and ...
- 129
1
vote
2
answers
772
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 ...
- 163
0
votes
1
answer
45
views
Update date with date field in another table
I'm wanting to update the date field in one table with the date from another table. Below is an example snippet of what I'm trying to achieve.
ln.[DateEntered] AS 'acc.[...
- 25
-1
votes
2
answers
493
views
Why is my join query returning Malformed query?
I have two tables -- RecordType and CventSession__c. THe CventSession__c has a RecordTypeId field taht links back to the RecordType table. How do I write a query to get the CventSession__c.ID and ...
- 87
2
votes
1
answer
9k
views
How to join User, GroupMember and Group in SOQL?
How can I return User.Email and Group.Name from SOQL?
I want the group names and the email addresses of their members from a query like:
SELECT User.Id, User.Email, Group.Name from User
WHERE Id IN
...
- 257
2
votes
1
answer
332
views
What is the maximum number of rows retrieved in a SOQL NOT IN clause?
What is the maximum number of rows, which can be queried inside a NOT IN clause? For example, let's say I have this query:
SELECT Id FROM Campaign WHERE Id NOT IN (
SELECT xxx__campaign__c FROM ...
- 492
0
votes
1
answer
2k
views
Is there a way to go from Task -> Case?
I have a SOQL query that is returning records that should not be returned.
As a little backstory - To solve this, I added on a IN clause to the end of my query but I am getting "Entity 'Task' is not ...
- 3,429
2
votes
1
answer
2k
views
I have a Parent->Child->GrandChild .. I need one object constructed and returned for a rest call
I need to construct one object that will return Forms->Section->Question
The objects are Master-Child relationships in the above order.
Please let me know how I can construct this object. Appreciate ...
1
vote
2
answers
2k
views
SOQL - Left Join Help
I am not getting the right results back from my join query. I want all Employee_Benefit_Summary__c records that have a Grand_Total_Premium__c value greater than 0 that do not have any related ...
- 1,473
5
votes
3
answers
24k
views
Converting SQL to SOQL
I am transitioning to learning SOQL and am struggling with some basic concepts (specifically, joining tables and using multiple tables in the where clause). Can you help me figure out how the below ...
- 373
0
votes
1
answer
170
views
LEFT ANTI JOIN SOQL on a non-indexed field [closed]
While doing a left anti join in soql on a non-indexed field. The query is failing with QUERY_TIMEOUT.
'QUERY_TIMEOUT: Your query request was running for too long.'
Here is my query-
SELECT ID,...
2
votes
1
answer
10k
views
SOQL joining multiple tables to get account info from record owner
So I have a custom object standard controller and I want to auto-populate a field on a form from the users account record.
In preparation to build my controller I need a valid SOQL statement and I'...
- 1,620
0
votes
1
answer
1k
views
BATCH Class - Inner Queries - Questions/Doubts [closed]
I am doing few thing in Batch - and I was curious whether :
My SOQL Queries will work with 50000+ records ?
Will my SOQL's take too much time to execute and cause Time Out, etc ?
SOQL
SELECT id, ...
- 2,150
0
votes
1
answer
1k
views
SOQL join two tables - all contacts from lead
I have a Lead object and would like to get all contacts for this Lead. I was not able to find an appropriate method in apex and decided to make a query. Unfortunately I don't have much experience with ...
- 568
15
votes
1
answer
14k
views
Single SOQL query for Accounts without Contacts
How to query those Account which has not any related Contacts ? I have Queried Account and contact in inner query. I found All Account with that Account I looped and find those Account whose Contact ...
- 664
1
vote
1
answer
635
views
SOQL Inner query pageblocktable
I have Application object and References as Child object.
I want to display list of Applications and corresponding "number of References records" for each application in VF Page. There is a status ...
- 4,055