You need to sign in to do that
Don't have an account?
111
select a.ID from PricebookEntry a Product2 b where Product2.ProductCode =:productCode
select a.ID from PricebookEntry a Product2 b where Product2.ProductCode =:productCode
error is appeared.
unexpected token: Product2
how can i make the SOQL[select a.ID from PricebookEntry a Product2 b where Product2.ProductCode =:productCode ] to be right?
you can also use the 'salesforce.schema' in the eclipse plugin to create your SOQL by clicking the required feilds and expanding references to produce the following: