I have Detail table with the lookup relation table (Status). I'm able to take the records from the detail table, but i do not know how to take the value from status table.
Below i have given the query
Lookup Table :: Status_c
It's Column :: Status_name__c & Status_Code__c
from the below selection how to take the Status_name__c & Status_Code__c column values from Status_c table.
QUERY SELECT Width__c, Status__c FROM Detail__c detail WHERE detail.Status__r.Status_Code__c = 'B' AND detail.Packaging_Id__c = : Id
Kindly help me. In case any further information please let me know.