表A、B; SELECT 'A表' as 'TableName',* FROM A UNION SELECT 'B表' as 'TableName',* FROM B 转载于:https://www.cnblogs.com/fjzhang/archive/2013/03/16/2963400.html