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
The documentation is pretty clear, you have to include the external table as a subquery:
FROM Sample.Person,(SELECT * FROM Mylink.Person)
That means that you have to modify your view to use the external table in that way.
Thank you Luis, I have updated query and it is working fine. Thank you so much for your response.