Originally I had written the below basic query in an Access db and was connecting through ODBC.
However, since this is now set up to automatically generate daily on a trigger, I need to get the script into Qlik.
Could someone please offer advice on what I may be doing incorrectly as I keep getting syntax errors.
<ODBC Connect to...>
FROM SISI."CNC_COMMENT" cnc
ON (cnc."PATIENT_ID" = pat."PATIENT_ID")
WHERE cnc."CNC_TYPE" = 'Flip Room Case'
remove the quotes.
FROM SISI.CNC_COMMENT cnc
ON (cnc.PATIENT_ID = pat.PATIENT_ID)
WHERE cnc.CNC_TYPE = 'Flip Room Case'