select
t1_id,
t1_name,
t2_id,
t2_name
from
(select id as t1_id,
(case when name is null then '空' end) as t1_name --判断name为空时指定一个值
from test1
)tb1,
(select id as t2_id,
name as t2_name
from test2
)tb2
);
select
t1_id,
t1_name,
t2_id,
t2_name
from
(select id as t1_id,
(case when name is null then '空' end) as t1_name --判断name为空时指定一个值
from test1
)tb1,
(select id as t2_id,
name as t2_name
from test2
)tb2
);