SELECT DISTINCT incident, projectname,
(SELECT applier
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applierM, --applier 与已有列名重名
(SELECT applydate
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applydate,
(SELECT feenumber
FROM ULT_bxiao_head
WHERE incident = b.incident) AS feenumber
FROM ULT_bxiao_detail b
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident)) AND (applier LIKE '%n%') AND (applydate = '2003-5-15')
(SELECT applier
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applierM, --applier 与已有列名重名
(SELECT applydate
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applydate,
(SELECT feenumber
FROM ULT_bxiao_head
WHERE incident = b.incident) AS feenumber
FROM ULT_bxiao_detail b
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident)) AND (applier LIKE '%n%') AND (applydate = '2003-5-15')
解决方案 »
- 怎么会提示 对象名无效?
- 我想用SQL来存文件。存入多大文件比较合适
- 求一个汇总的sql
- 请星级大师来帮我看看!!!!!!!!!!!!!!!
- text类型如何转换为nvarchar类型
- varchar转datetime
- 不要看给分少就不回答这个问题,因为我没分了( ODBC连接SQL Server的问题 很简单)
- 谁学mcse的SQL书时做过bookshopdb这个数据库文件,能备份下来发给我吗? 急用~~~~~~~~~~~~!!!!!!!!!
- 请教Win2K的数据源的配置
- sql2000数据库如何打包
- select @m3 = 4
- 我想在我的存储过程中调用系统存储过程sp_addlinkedsrvlogin,出错???
(SELECT applier
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applier
FROM ULT_bxiao_detail b
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident)) AND (applier LIKE '%n%')
也提示无效的列!applier
但是
SELECT incident, projectname,
(SELECT applier
FROM ULT_bxiao_head
WHERE incident = b.incident) AS applier
FROM ULT_bxiao_detail b
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident)) AND (incident>1)
却可以正确执行!
FROM ULT_bxiao_detail b,ULT_bxiao_head A
WHERE A.incident = b.incident
and (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident)) AND (A.applier LIKE '%n%')
(SELECT applier
FROM ULT_bxiao_head
WHERE incident = b.incident AND (applier LIKE '%n%')) AS applier
FROM ULT_bxiao_detail b
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident))
WHERE (projectname =
(SELECT TOP 1 projectname
FROM ULT_bxiao_detail
WHERE b.incident = incident))
后加applier like ...
j9988,谢谢你的回复,但是因为查询后结果有重复所以你的不行,否则我早用了,请再帮我想想办法!。