select distinct aa=isnull(a.aa,isnull(b.aa,isnull(c.aa,isnull(d.aa.....))))
a.bb,a.cc,b.dd,d.ee....
into abc表
from a full join b on a.aa=b.aa
full join c on a.aa=c.aa
full join d on a.aa=d.aa
....
a.bb,a.cc,b.dd,d.ee....
into abc表
from a full join b on a.aa=b.aa
full join c on a.aa=c.aa
full join d on a.aa=d.aa
....
解决方案 »
- 删除一个字段中包含“三”的所有数据(表USER,USERNAME)?
- 这么晚了不知道大家还在不在线上,一个存储过程的问题,实在无奈了。
- 如何断开链接服务器
- 虚拟机上装MSSQL2000,如何连接
- 为什么datetime类型的字段允许为空时,他default值都是1900-01-01 啊?
- 回答正确100分送去关于一个SQL SERVER 2000 命令
- 请问哪里可以免费下载SQL Server 2000?
- 关于delete语句的一个问题
- 如何来写一个删除的TRIGGER,具体要求如下:(坚决放分)
- 2个问题:建立replication后Identity属性不能复制;手工同步方法
- 哪里有SQL Server 2000的 查询分析器 的组件下载?
- 請教一簡單SQL語句,關於結果合併的.謝謝大家
把他们做一定处理?
A表:AA,BB,CC
B表:AA,DD
C表:DD,EE
D表:AA,DDDD这个字段要总表都需要显示,可是每个表的DD存放的数据都不一样。怎么办??有办法吗??
(d.pe_usename,isnull(f.pe_usename,isnull(g.pe_usename,isnull(h.pe_usename,isnull
(i.pe_usename,isnull(j.pe_usename,isnull()))))))))
a.SC_ID,a.SEX,a.Birth,b.Edc_Level,b.University,b.Enroll_time,b.SPECNAME1,b.SPECNAME2,c.id,c,Edclevel,d.Work_site,
e.Region,f.last_update,f.last_login,g.position1,g.position2,g.position3,h.work_resume
i.ab_desc,j.pe_desc,k.ID,k.top_id,L.specialty,L.top_id
into lldtest
from pe_base a full join pe_edc b on a.pe_usename=b.pe_usename
full join Sy_EDCLevel c on b.EDC_level=c.id
full join pe_Contact d on d.pe_usename=a.pe_usename
full join Sy_area e on e.id=d.work_site
full join pe_log f on f.pe_usename=a.pe_usename
full join pe_Condition g on g.pe_usename=a.pe_usename
full join pe_work h on h.pe_usename=a.pe_usename
full join pe_Ability i on i.pe_usename=a.pe_usename
full join pe_Desc j on j.pe_usename=a.pe_usename
full join sy_position k on k.ID=g.position1 or k.id=g.position2我按上面的作法写了一下:
出错提示:
服务器: 消息 174,级别 15,状态 1,行 3
isnull 函数要求有 2 个参数。
(d.pe_usename,isnull(f.pe_usename,isnull(g.pe_usename,isnull(h.pe_usename,isnull
(i.pe_usename,isnull(j.pe_usename,''))))))))
,a.SC_ID,a.SEX,a.Birth,b.Edc_Level,b.University,b.Enroll_time,b.SPECNAME1,b.SPECNAME2,c.id,c,Edclevel,d.Work_site,
e.Region,f.last_update,f.last_login,g.position1,g.position2,g.position3,h.work_resume
,i.ab_desc,j.pe_desc,k.ID,k.top_id,L.specialty,L.top_id
into lldtest
from pe_base a full join pe_edc b on a.pe_usename=b.pe_usename
full join Sy_EDCLevel c on b.EDC_level=c.id
full join pe_Contact d on d.pe_usename=a.pe_usename
full join Sy_area e on e.id=d.work_site
full join pe_log f on f.pe_usename=a.pe_usename
full join pe_Condition g on g.pe_usename=a.pe_usename
full join pe_work h on h.pe_usename=a.pe_usename
full join pe_Ability i on i.pe_usename=a.pe_usename
full join pe_Desc j on j.pe_usename=a.pe_usename
full join sy_position k on k.ID=g.position1 or k.id=g.position2