select isnull(a.name,b.name) as [name],
fcount,
Lcount
from table1 a full join table2 b on a.name=b.name
fcount,
Lcount
from table1 a full join table2 b on a.name=b.name
解决方案 »
- sql行专列问题
- 紧急求援 误删了sysusers里guest 这条记录 现在怎么恢复?
- 帮忙看看这个sql语句怎么写?
- 我怎么装不上啊!(系统Win2000 professional,SQL server 个人版)
- bbs 论坛系统需要哪几个表
- 在线等待,急用!powerbuilder 8.0 连接sql server 7.9 数据库远程ip的问题
- SQL 2000启动问题!!(急急......谢谢各位回贴的朋友了)
- for insert的触发器语句应该如何写!!???
- 怎么查询一个table是不是这个库里面的
- sqlce 與SQLSERVER同步
- 怎样获得数据库服务器的当前日期?
- 输入参数里面不能含有变量嘛?怎么解决?
Into #tmp
from table1
union
select Name ,fount=0 ,Lcount
from table2 select Name ,fount=max(isnull(fount,0)),Lcount =Max (isnull(Lcount,0 ))
from #tmp
Into #tmp
from table1
union
select Name ,fount=0 ,Lcount
from table2 select Name ,fount=max(isnull(fount,0)),Lcount =Max (isnull(Lcount,0 ))
from #tmpgroup by name
union
select b.name,Fcount,Lcount from table2 b right join table1 a on a.name=b.name