Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
0

Questions
2

Replies

how to transfer SQL to SOQL

I have SQL query here, can you help to transfer to SOQL?

Select o.OpportunityId from OpportunityLineItem o inner join PricebookEntry PE on o.PricebookEntryID=PE.ID inner join Product2 P on PE.product2ID=P.Id where P.Id in
(select Product2.Id from Product2 where Product2.Family not LIKE 'Service%')

Thanks,

Cassie

cassie
September 11, 2008
Like
0