I have a multiple table query that has an “or” statement in it. I cannot seem to find a way to add another “or” statement. Is there some way to add another “or” statement to the query without submitting it to the editor. I have tried that and am apparently not versed enough in SQL to do it properly.
I would like to add:
VISIT_CHARGES_V.FACILITY_ID = 1
VISITS_V.PATIENT_CLASS <> ‘E’
MST_CHARGES_V.GL_DEPT = 10320
VISIT_CHARGES_V.SERVICE_DATE BETWEEN LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE), -2)) + 1 AND LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE), -1))
The TSM and SQL are attached.
NEW SAM_OR.tsm (344 KB)
Original SAM_OR.docx (15.6 KB)