bundlewithProduct = [SELECT Id, (select Product__c from Product_Quantities__r) FROM Bundle__c WHERE Id =: QBP.Bundle__c];
from the above mentioned query i am getting the list of bundle with it's Product Quantity
Now, i have one string ListPrice
and fill this string with ListPrice of selected Product from bundlewithProduct
i am bit confuse about how to put [select Product__c from Product_Quantities__r]
in where clause of the following query
this.ListPrice = string.ValueOf([SELECT Id, Product2Id, UnitPrice FROM PriceBookEntry where Product2Id =: ______________________);
can anyone please tell me how to achieve this ?
Product_Quantities__c
andPriceBookEntry
are related?