• Victor Bogolyubov
  • NEWBIE
  • 10 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hello,
I got Unknown error parsing query error. Can somebody explain what is going on, please? Thank you.

1. This is OK
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Account__r.OwnerId != '0056C000003GwJnQAK'
LIMIT 20

2. This is OK too
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Contact__r.OwnerId != '0056C000003GwJnQAK'
LIMIT 20

3. But THIS one is Unknown error parsing query
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Contact__r.OwnerId != Account__r.OwnerId
LIMIT 20
 
Hello,
I got Unknown error parsing query error. Can somebody explain what is going on, please? Thank you.

1. This is OK
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Account__r.OwnerId != '0056C000003GwJnQAK'
LIMIT 20

2. This is OK too
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Contact__r.OwnerId != '0056C000003GwJnQAK'
LIMIT 20

3. But THIS one is Unknown error parsing query
SELECT Contact__r.Id, Contact__r.OwnerId, Account__r.Id, Account__r.OwnerId, Student__r.OwnerId
FROM Student_Relationship__c
WHERE Student__r.OwnerId  !='0056C000003GwJnQAK'
  AND Contact__r.OwnerId != Account__r.OwnerId
LIMIT 20