56,940
社区成员




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