Table 7 Join example — Encounter view result
From: SQL on FHIR - Tabular views of FHIR data using FHIRPath
encounter_id | patient_id | encounter_date |
|---|---|---|
encounter-1 | patient-1 | 2023-01-01 |
encounter-2 | patient-2 | 2023-02-15 |
encounter-3 | patient-1 | 2023-03-10 |
From: SQL on FHIR - Tabular views of FHIR data using FHIRPath
encounter_id | patient_id | encounter_date |
|---|---|---|
encounter-1 | patient-1 | 2023-01-01 |
encounter-2 | patient-2 | 2023-02-15 |
encounter-3 | patient-1 | 2023-03-10 |
