try:select f_khbm,f_chbm,f_xsjg from (select top 1 N.f_khbm,N.f_chbm,N.f_xsjg,K1.f_jb,P1.f_jb from tbda_kh_sj N left outer join tbda_kh K1 on N.f_khbm=K1.f_khbm left outer join tbda_kh K2 on K2.f_khbm like N.f_khbm+'%' left outer join tbda_ch P1 on N.f_chbm=P1.f_chbm left outer join tbda_ch P2 on P2.f_chbm like N.f_chbm+'%' where K2.f_khbm='001001' and P2.f_chbm='1001001001' order by K1.f_jb desc,P1.f_jb desc)A
union all
select '' as f_khbm,f_chbm,f_bzsj as f_xsjg from tbda_ch_bz where f_chbm='1001001001' and f_xh=0
union all
select '' as f_khbm,f_chbm,f_bzsj as f_xsjg from tbda_ch_bz where f_chbm='1001001001' and f_xh=0
解决方案 »
- 新手求教,能查询到表中列名的中文定义吗?
- 求ORACLE10的入门的电子文档
- 四表联合查询的问题.
- 统计记录数的复合SQL语句问题
- 怎用SQL语句提这些树型数据?
- 报错为"在bcp数据文件中遇到意外的EOF"如何解决呢?谢谢!
- VC6.0中的编译、连接与运行源程序的各应用程序在安装目录的哪些文件夹下?
- 我有一个SQL Server6.5的数据库备份文件(*.dat),有没有人知道我怎样才能将这个数据库还原到SQL Server2000中
- SQL查詢!!
- pb建不了数据库(sabese anywhere)为什么?
- [求助]用SQL语句可以写入带Blob Field字段的数据库记录吗?
- 把select into出来的新表建在另一个文件组中
(select f_khbm,f_chbm,f_xsjg from (select top 1 N.f_khbm,N.f_chbm,N.f_xsjg,K1.f_jb as f_khjb,P1.f_jb from tbda_kh_sj N left outer join tbda_kh K1 on N.f_khbm=K1.f_khbm left outer join tbda_kh K2 on K2.f_khbm like N.f_khbm+'%' left outer join tbda_ch P1 on N.f_chbm=P1.f_chbm left outer join tbda_ch P2 on P2.f_chbm like N.f_chbm+'%' where K2.f_khbm='001001' and P2.f_chbm='1001001001' order by K1.f_jb desc,P1.f_jb desc)A
union all
select '' as f_khbm,f_chbm,f_bzsj as f_xsjg from tbda_ch_bz where f_chbm='1001001001' and f_xh=0 ) B
order by f_khbm desc
指定结果集的排序。除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。语法
[ ORDER BY { order_by_expression [ ASC | DESC ] } [ ,...n ] ]参数
order_by_expression指定要排序的列。可以将排序列指定为列名或列的别名(可由表名或视图名限定)和表达式,或者指定为代表选择列表内的名称、别名或表达式的位置的负整数。 可指定多个排序列。ORDER BY 子句中的排序列序列定义排序结果集的结构。ORDER BY 子句可包括未出现在此选择列表中的项目。然而,如果指定 SELECT DISTINCT,或者如果 SELECT 语句包含 UNION 运算符,则排序列必定出现在选择列表中。此外,当 SELECT 语句包含 UNION 运算符时,列名或列的别名必须是在第一选择列表内指定的列名或列的别名。
---看联机帮助
select top 1 f_xsjg from
(select f_khbm,f_chbm,f_xsjg
from (select top 1 N.f_khbm,N.f_chbm,N.f_xsjg
from tbda_kh_sj N left outer join tbda_kh K1
on N.f_khbm=K1.f_khbm left outer join tbda_kh K2
on K2.f_khbm like N.f_khbm+'%' left outer join tbda_ch P1
on N.f_chbm=P1.f_chbm left outer join tbda_ch P2
on P2.f_chbm like N.f_chbm+'%'
where K2.f_khbm='001001' and P2.f_chbm='1001001001'
order by K1.f_jb desc,P1.f_jb desc)A
union all
select '' as f_khbm,f_chbm,f_bzsj as f_xsjg
from tbda_ch_bz
where f_chbm='1001001001' and f_xh=0 ) B
' (select * from (select top '+IntToStr(FTopN)+' N.f_rzrq,N.f_khbm,isnull(kh.f_khmc,'''') as f_khmc, '+
' S.f_chsl,S.f_hsdj '+
' from tbnote_xscb S '+
' left outer join tbnote_xszb N on S.f_djhm=N.f_djhm '+
' left outer join tbda_kh kh on N.f_khbm=kh.f_khbm '+
' where S.f_chbm='''+FChbm+''' and N.f_khbm='''+FKhbm+''''+FSql+
' order by N.f_rzrq '+
' )A '+
' union all '+
' select * from (select top '+IntToStr(FTopN)+' N.f_rzrq,N.f_khbm,isnull(kh.f_khmc,'''') as f_khmc, '+
' S.f_chsl,S.f_hsdj '+
' from tbnote_xscb S '+
' left outer join tbnote_xszb N on S.f_djhm=N.f_djhm '+
' left outer join tbda_kh kh on N.f_khbm=kh.f_khbm '+
' where S.f_chbm='''+FChbm+''' and N.f_khbm<>'''+FKhbm+''''+FSql+
' order by N.f_rzrq '+
' )B'+
' )C ';
select '''' 為'
每次看一个简单字段都要关联n个表,麻烦,简直是折磨我们开发人员,那不如折磨数据库,让他存取多点字段,只要我们忘资料库insert时候保证了字段的关联一致性即可FYI