如何查询3张表的各自最后10条不相同的数据 并用union联接显示呢？
------解决思路----------------------
SELECT * FROM(
SELECT TOP 10 * FROM 表1
ORDER BY date
)T1
UNION ALL
SELECT * FROM(
SELECT TOP 10 * FROM 表2
ORDER BY date
)T2
UNION ALL
SELECT * FROM(
SELECT TOP 10 * FROM 表3
ORDER BY date
)T3