CREATE INDEX oix1 ON organizations(NAME,Id);
CREATE INDEX eix1 ON encounters(ORGANIZATION, STARTDATE, PATIENT);
CREATE INDEX pix1 ON patients(Id, FIRST_NAME, LAST_NAME);
WITH orgIds AS (SELECT RAW o.Id
FROM organizations AS o
WHERE o.NAME = "Beverley hospital")
SELECT p.FIRST_NAME, p.LAST_NAME, e.PATIENT
FROM encounters AS e
JOIN patients AS p ON p.Id = e.PATIENT
WHERE e.STARTDATE = "2011-08-18T01:28:03Z" AND e.ORGANIZATION IN orgIds;
thanks a lot
the first give me
“msg”: “syntax error - at JOIN”,
i tried another
SELECT patients.FIRST_NAME,
patients.LAST_NAME,
encounters.PATIENT
FROM patients
JOIN encounters ON patients. Id = encounters. PATIENT
AND encounters. STARTDATE = "1999-10-08T10:07:55Z"
JOIN organizations ON organizations. Id = encounters. ORGANIZATION
AND organizations. NAME= "BEVERLY HOSPITAL CORPORATION"