56,687
社区成员
发帖
与我相关
我的任务
分享
select table1.dateline,table1.value1,table2.value2
from table1 left jion table2 on table1.tid=table2.tid
union
select table2.dateline,table1.value1,table2.value2
from table1 right jion table2 on table1.tid=table2.tid
where table1.tid is null