I read some other questions but I'm still having trouble.
I' ve got Custom object
A has got a LookUp relationship field on
I'd like to get the value of Name of B. This is the query I'm using:
SELECT Name FROM B WHERE id =: A.LookUpB__c
What am I doing wrong?