老问题了,可以通过建临时表/表匹配记录的方式:SELECT * FROM AA WHERE AID IN (1,2,3,...);==>SQL> SELECT BID FROM BB;BID ------------------------------1 2 3 ...SELECT * FROM AA WHERE EXISTS (SELECT 1 FROM BB WHERE AA.AID = BB.BID);
那你用union吧,把记录分成多份,然后用union合起来 SELECT * FROM WHERE AA IN (1,2,3,4) UNION SELECT * FROM WHERE AA IN (5,6,7,8)
WHERE AID IN (1,2,3,...);==>SQL> SELECT BID FROM BB;BID
------------------------------1
2
3
...SELECT * FROM AA
WHERE EXISTS (SELECT 1
FROM BB
WHERE AA.AID = BB.BID);
SELECT * FROM WHERE AA IN (1,2,3,4)
UNION
SELECT * FROM WHERE AA IN (5,6,7,8)
谢谢了