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''))
- ')
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amira BedhiafiPosted Apr 16, 2021, 3:26 PM