Openquery中的openquery

Question

是否可以在openquery中执行openquery

通过SQL Server从MySQL工作台调用openquery时，出现以下错误：

select * from openquery ([ABS],
         'select * from sales_payments 
          where receipt_id not in 
                (select * from openquery ([ABS], ''select distinct receipt_id from receipt''))
         ')

Answer 1

为什么不用NOT IN代替INNER JOIN呢？

SELECT * FROM openquery ([ABS],
     'SELECT * FROM sales_payments AS s
     INNER JOIN  receipt AS r 
     ON s.receipt_id =r.receipt_id
     WHERE r.receipt_id IS NULL')

或者简单地说：

SELECT * FROM openquery ([ABS],

'SELECT * FROM sales_payments AS s
 WHERE s.receipt_id NOT IN  (SELECT distinct receipt_id FROM receipt)')