what’s the relationship among Product , PriceBook and PriceBookEntries in salesforce?

Hi suraj,

Here’s a schematic of the relationships involved.

Products are related to Pricebook via the PriceBookEntry (junction) Object. OpportunityLineItems look up to the PriceBookEntry Object, rather than looking up directly to Product2.

Therefore if you want to select Products with Opportunities, it will have to be via the PriceBookEntry Relationship.

Thanks.