Question reetan selvaraja · Dec 9, 2022 Link Table wizards is not working with SQL joins Hi, I tried to join my local DB table with link table. but I am getting below error. 5475 5475 reporterr2+40^%occRoutine Error #5475: Error compiling routine: %sqlcq.HSANALYTICS.cls483. Errors: %sqlcq.HSANALYTICS.cls483.cls(%OnNew+5) : SQLCODE=-161 : References to an SQL connection must constitute a whole subquery I tried to execute below query in Managementportal select dg.ID from HSAA.Diagnosis dgleft join LinkTableData.FacilityFullList la on dg.ID=la .ID #SQL #InterSystems IRIS 0 4 0 140
Questions