I am running the following query in salesforce to get the country
SELECt name, owner.country from lead
This gives the following error:
No such column 'country' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
However this works just fine if I do
SELECt name, owner.id from lead SELECt name, owner.username from lead SELECt name, owner.name from lead
It gives the data