22,210
社区成员
发帖
与我相关
我的任务
分享
select datetime, user_id, money,0 as score, remark from 第一张表
union all
select datetime ,user_id ,0 as money,score, remark from 第二张表
select datetime, user_id, money,0 as score, remark from 第一张表
union all
select datetime ,user_id ,0 as money,score, remark from 第二张表
select a.datetime,a.user_id,isnull(a.money,0) money,isnull(b.score,0)score ,a.remark
from 表1 a left join 表2 b on a.user_id=b.user_id and a.datetime=b.datetime