id name score
1 a 70
2 b 60
id name day
1 a 20090312
3 c 20090313结果id name score day
1 a 70 20090312
2 b 60 0
3 c 0 20090313
1 a 70
2 b 60
id name day
1 a 20090312
3 c 20090313结果id name score day
1 a 70 20090312
2 b 60 0
3 c 0 20090313
调试欢乐多
from a join b on a.id=b.id
;
select id,name,score,day from table1
full outer join table2 on table1.id=table2.id
full outer join t2 on t1.id=t2.id AND t1.name=t2.name