请问如何将两列表合并为一列？
例如:
已编辑
first_table
id | folder | category id | status
1 Peter 5 0
2 John 6 1
3 Shawn 7 0
second_table
id | filename| category id
1 123.sql 9
2 you.png 12
3 it.pdf 11
我希望预期结果如下，列文件夹和文件名成为存储在1列和列名为folder_filename:
第一个表连接第二个表
id | folder_filename| category id | status
1 Peter 5 0
2 John 6 1
3 Shawn 7 0
4 123.sql 9
5 you.png 12
6 it.pdf 11
我尝试了下面的sql，但不确定如何修改使它工作。
SELECT * FROM first_table INNER JOIN second_table
希望有人能指导我如何解决。 谢了。
您似乎希望Union All:
select f.id, f.folder, f.category_id
from first_table f
union all
select s.id, s.folder, s.category_id
from second_table s;
编辑:
如果您确实想要更改ID，那么:
select row_number() over (order by which, id) as id, folder, category_id
from ((select f.id, f.folder, f.category_id, 1 as which
from first_table f
) union all
(select s.id, s.folder, s.category_id, 2
from second_table s
)
) fs
) fs
