![]() |
#2
z0608312016-01-19 11:25
|
怎么样可以更方便的合并查询这两个数据库?每次查询都用union太麻烦的了。我现在的做法是这样的:

SELECT *
FROM a.TABLE
UNION ALL
SELECT *
FROM b.TABLE T
WHERE NOT EXISTS(SELECT 1 FROM a.TABLE T2 WHERE T2.ID=T.ID)
FROM a.TABLE
UNION ALL
SELECT *
FROM b.TABLE T
WHERE NOT EXISTS(SELECT 1 FROM a.TABLE T2 WHERE T2.ID=T.ID)