1.在oracle中语句如下:
select * from tableName where owner IN ('DBName1','DBName2')
2.在MySql中语句如下:
SELECT * FROM DBName1.tableName UNION ALL SELECT * FROM DBName2.tableName
3.在SQLServer中语句如下:
SELECT * FROM DBName1.tableName UNION ALL SELECT * FROM DBName2.tableName
参考:http://www.itpub.net/thread-1808304-1-1.html