Apex Code Development You need to sign in to do that
Don't have an account?
Yash Wants to reterive data from two custom object in single SOQL
Hi,
I want to reterive the data from two custom objects in a single query.
I tried following snippet.
[select Category_Name__c,Item_Number__c,Item_Description__c,Upc__c,Sellable__c from Item_Master__c I,Category_Master__c C where I.Category_Id__c = C.Category_Id__c ];
But it is giving following error:
Error: Compile Error: unexpected token: C.Category_Id__c at line 90 column 163
Can anybody have solution for this?
Thanks
Yash
I want to reterive the data from two custom objects in a single query.
I tried following snippet.
[select Category_Name__c,Item_Number__c,Item_Description__c,Upc__c,Sellable__c from Item_Master__c I,Category_Master__c C where I.Category_Id__c = C.Category_Id__c ];
But it is giving following error:
Error: Compile Error: unexpected token: C.Category_Id__c at line 90 column 163Can anybody have solution for this?
Thanks
Yash
Your SOQL is not formatted correctly.
Try using Force Explorer, it helps building the SOQL statements.
The two custom object can only be in one statement if they have a "RELATIONSHIP" (master-detail or lookup).