mysql - SQL 联盟 : Selecting id of file_up table

Question

我有两个表treeview_items和file_up

treeview_items

file_up

还有一个查询(不是我写的)

SELECT *
FROM treeview_items
UNION
    SELECT id + (select max(id) from treeview_items), name, 
          path as text,dir_id as parent_id
    FROM file_up

现在如何修改此查询，以便 file_up 表中的 id 也将列在查询结果中？我尝试了一些方法，但仍然卡住了!

当前输出和预期输出，这里列名id from file_up仅供演示。

Answer 1

不确定我是否完全明白你在说什么，但你在寻找这样的东西吗？

SELECT *, WhateverID = NULL
FROM treeview_items
UNION
    SELECT id + (select max(id) from treeview_items), name, 
          path as text,dir_id as parent_id, WhateverID
    FROM file_up