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!
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityI 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