史萊姆論壇 - 查看單個文章

劍痞憶秋年 · 2010-03-31, 12:05 AM

參考看看

select case when a.name is null then b.name else a.name end ,case when b.grade is null then 0 else b.grade end as grade ,
case when a.number is null then 0 else a.number end as number from a full join b on a.name=b.name

2010-03-31, 12:05 AM	#2 (permalink)
劍痞憶秋年長老會員榮譽勳章勳章總數4 UID - 15 在線等級: 註冊日期: 2002-12-06 住址: 步雲崖文章: 280 精華: 0 現金: 15847 金幣資產: 20867 金幣	參考看看 select case when a.name is null then b.name else a.name end ,case when b.grade is null then 0 else b.grade end as grade , case when a.number is null then 0 else a.number end as number from a full join b on a.name=b.name
	__________________ 一切有為法如夢幻泡影如露亦如電應作如是觀
	送花文章: 150, 收花文章: 33 篇, 收花: 130 次