A SoQL query returns a salesforce object on a look up field. E.g. a long name:
a80000000012345
How do i query that object and get it's fields instead of the salesforce id? I need the name from that salesforce object id.
Example query that is similar to my problem. Fields are made up. I need a list of books from a category:
select category__c from book__c
I have a category table too though:
select name from book_category_c