Table 8 Join example — Final joined result
From: SQL on FHIR - Tabular views of FHIR data using FHIRPath
patient_id | name | family | encounter_id | encounter_date |
|---|---|---|---|---|
patient-1 | Aisha | Khan | encounter-1 | 2023-01-01 |
patient-1 | Aisha | Khan | encounter-3 | 2023-03-10 |
patient-2 | Juan | Rodriguez | encounter-2 | 2023-02-15 |
