Hi, how can I extract values from 2 different table, ServicePoint and Facility, where a ServicePoint is always linked to one Facility? I would a list of ServicePoint id and information about related Facility.
I would extract:
ID_SERVICE_POINT (field present in ServicePoint)
ADDRESS (field present in Facility)
CITY (field present in Facility)
In ServicePoint I have a field called facility where I have the id of the related Facility.