I Have a Salesforce Org where there are almost 1000 products and 51 Price books, I want to know a query where I can get each product and the price books they belong to.

Any help is much appreciated!

Select Id, Name, Pricebook2.Id, Pricebook2.Name FROM Product2

but you should read up on SOQL in general because this is a rather basic question, you should be able to expand on this rather easily

  • Yeah im only recently a certified admin and am starting to learn about development tools. so im still pretty new to it all. Oct 26 '18 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.