Question

SQL 视图 合并两个表中的date字段

怎么实现这样的效果

Answer 1

要看是什么数据库，才能回答

select t1.date1,t1.mysum1,t2.mysum2
from tab1 t1 left join tab2 t2 on t1.date1=t2.date2

Answer 2

select a.date1,a.mySum1,b.mySum2
from tab1 as a left join tab2 as b
on a.date1 = b.date2