I have a Salesforce query which is pulling all the necessary columns from Opportunity table. It is something like that
Select o.Opportunity_ID__c, o.LastModifiedDate, o.Opportunity_Currency__c, o.Opportunity_Type__c FROM Opportunity o ORDER BY o.LastModifiedDate ASC
All I need is to add one more column. This column is called "EmployeeNumber" in "User" table.
When I loo at Opportunity fields, there is a lookup which is pulling this data called "Opportunity Owner" field in "Opportunity" table.
I tried couple of sub queries which didn't work. Some of the solutions I have seen on Google search; they say, look for Child Relationships. I did but there is no such a child relationship saying "User" or "Owner" under Opportunity child relationship (I used Eclipse for that)
Can you please help me? Thank you