Question
· Apr 11

Select View throwing Error "References to an SQL connection must constitute a whole subquery"

Hi,

I have created view from External table joins internal persistent table. Create VIEW worked but Select * from Viewxxx throwing error.

"References to an SQL connection must constitute a whole subquery"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...(SELECT%20*%20FROM%20Mylink.

Could it possible to create view with external db table with local persistant table and to access it?

please suggest any thoughts on it..

Thanks,

Product version: IRIS 2022.3
Discussion (2)2
Log in or sign up to continue