SOQL - salesforce object query language Why i am getting this error in the below query Here is the query - List productList = [Select Id, Name, Parent_Product__c, IsActive, Description, Account__c, (Select Id, Product2Id, Quantity From OrderItem) From Prod2 Where Account__c = 'XYZ']; ERROR at Row:3:Column:70 I am not able to understand the relation between the OrderItem Object from the above query. Please resolve the error and provided me solution so i can solve it. Solve in Apex

• Computer Engineering lab

Apex
SOQL - salesforce object query language

Why i am getting this error in the below query

Here is the query -

List<Prod2> productList = [Select Id, Name, Parent_Product__c, IsActive, Description, Account__c, (Select Id, Product2Id, Quantity From OrderItem) From Prod2 Where Account__c = 'XYZ'];

ERROR at Row:3:Column:70

I am not able to understand the relation between the OrderItem Object from the above query.

Please resolve the error and provided me solution so i can solve it.

Solve in Apex