• Kent Georgeson
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
I have read the documentation that every points other similar questions to, but for the life of me I just can't get my head around this.

I have a very simple query
Select Id, Department, Email, FirstName, LastName, Phone From Contact
  Where Id IN (Select OwnerId From Case)
That gives me the error "The selected field 'OwnerId' in the subquery and the left operand field in the where expression in the outer query 'Id' should point to the same object type"

I want to return a list of contacts, but our contacts data is massive.  So I want to only return the contacts that are the owners of cases.   Any suggestions?
 
I have read the documentation that every points other similar questions to, but for the life of me I just can't get my head around this.

I have a very simple query
Select Id, Department, Email, FirstName, LastName, Phone From Contact
  Where Id IN (Select OwnerId From Case)
That gives me the error "The selected field 'OwnerId' in the subquery and the left operand field in the where expression in the outer query 'Id' should point to the same object type"

I want to return a list of contacts, but our contacts data is massive.  So I want to only return the contacts that are the owners of cases.   Any suggestions?