1
Answer

Openquery inside an openquery

Martin James

Martin James
3y
1.2k
1
Is it possible to use an open query inside another open query ?
  1. SELECT * FROM OPENQUARY([Test],  
  2. 'SELECT * FROM HR.Employee  
  3. WHERE DeptID NOT IN   
  4. (SELECT * FROM OPENQUERY ([Test],''SELECT DISTINCT DeptID  
  5. FROM HR.Departments''))  
  6. ')  
It is throwing an error when calling the open query from PostgreSQL to SQL Server 
Answers (1)
Next Recommended Forum