有没有办法在你的表名上使用"order"函数。 即我想合并两个表,然后按一列排序,然后按表名排序。
将常量添加到描述表名的列列表中,例如
select *, 'TableA' as TableName
from TableA
union all
select *, 'TableB' as TableName
from TableB
order by TableName
您可以
创建一个单独的列(假设您的列是col1
和col2
)
select col1,col2,table_1 as table_name
from table_1
union
select col1,col2,table_2 as table_name
from table_2
order by col1,table_name;