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!


1 Answer 1

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, 2018 at 10:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .