34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT MAX(ID) ID FROM
(
SELECT ID FROM TA
UNION ALL
SELECT ID FROM TB
)T
SELECT ID FROM TA
UNION ALL
SELECT ID FROM TB
select id from A union all select id from B
select max(id) as id
from
(select id from A union all select id from B) t
--所有值
SELECT ID FROM TA
UNION ALL
SELECT ID FROM TB
--最大值
SELECT MAX(ID) ID FROM
(SELECT ID FROM TA
UNION ALL
SELECT ID FROM TB
)T