Is it possible to use an open query inside another open query ?
- SELECT * FROM OPENQUARY([Test],
- 'SELECT * FROM HR.Employee
- WHERE DeptID NOT IN
- (SELECT * FROM OPENQUERY ([Test],''SELECT DISTINCT DeptID
- FROM HR.Departments''))
- ')
It is throwing an error when calling the open query from PostgreSQL to SQL Server