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 dg
left join LinkTableData.FacilityFullList la on dg.ID=la .ID
Product version: IRIS 2022.1