假设:
PingJiJG.ZhuTiJB *= PF.BianHao and
PF.PingJiFH = 'A+' 因为PF中的BianHao字段已经使用,所以后面的那个PF中的PingJiFH字段的那个‘=’号是没有判断效用的,如何使这两句同时起作用。
PingJiJG.ZhuTiJB *= PF.BianHao and
PF.PingJiFH = 'A+' 因为PF中的BianHao字段已经使用,所以后面的那个PF中的PingJiFH字段的那个‘=’号是没有判断效用的,如何使这两句同时起作用。
解决方案 »
- master..spt_values表的作用是什么,几个字段的含义是什么,谁能讲讲呢?
- 计算人数
- 关于COLUMNS_UPDATED在update时有且只有更新符合条件行时才更新的问题
- 请教在SQL作业里定时清空ACCESS某表数据的语句
- 怎样能“高效”剔除表中某列重复的行
- A 表和B表连接成一个记录A 和 B 的共同标识 TaskID,但有可能A里没有B中的TaskID cross, LEFT OUTER JOIN不能达到要求
- 急......关于带ntext类型参数的存储过程
- 不能调试存储过程
- 关于SQL的技巧,如何提高查询速度讨论
- 求助:sql2000事务日志的问题
- 查看历史记录
- 多表查询~
XiangMuJBXX.ShouPingZT as XiangMuJBXX_ShouPingZT ,
XiangMuJBXX.BianHao as XiangMuJBXX_BianHao ,
XiangMuJBXX.XiangMuJD as XiangMuJBXX_XiangMuJD ,
YeWuZLWH.YeWuZL as YeWuZLWH_YeWuZL ,
XiangMuJBXX.YeWuZLBH as XiangMuJBXX_YeWuZLBH ,
YeWuZLWH.ZhongLeiMC as YeWuZLWH_ZhongLeiMC ,
XiangMuJBXX.XiangMuMC as XiangMuJBXX_XiangMuMC ,
XT_ZuZhiJG.JG_MingCheng as XT_ZuZhiJG_JG_MingCheng ,
XiangMuJBXX.DGSuoShuHY as XiangMuJBXX_DGSuoShuHY,
HangYeFLWH.FenLeiMC as HangYeFLWH_FenLeiMC ,
v_ShouPingZT.DiQu as v_ShouPingZT_DiQu ,
XiangMuJBXX.JieShuSJ as XiangMuJBXX_JieShuSJ ,
PF.PingJiFH as zhutijib ,
PF1.PingJiFH as zhaixiangjibie
From PingJiJG PingJiJG,
PingJiFHWH PF,PingJiFHWH PF1,
XiangMuJBXX XiangMuJBXX,
v_ShouPingZT v_ShouPingZT,
XT_ZuZhiJG XT_ZuZhiJG,
HangYeFLWH HangYeFLWH,
YeWuZLWH YeWuZLWH
Where 1=1
and upper(XiangMuJBXX.XiangMuJD) = upper(5)
and v_ShouPingZT.bianhao =* XiangMuJBXX.ShouPingZT
and XiangMuJBXX.YeWuZLBH = YeWuZLWH.BianHao
and XiangMuJBXX.DangQianFZBM = XT_ZuZhiJG.BianHao
and XiangMuJBXX.DGSuoShuHY *= HangYeFLWH.BianHao
and upper(YeWuZLWH.YeWuZL) <> upper(4)
and XiangMuJBXX.BianHao = PingJiJG.XiangMuBH
and XiangMuJBXX.ShouPingZT NOT IN (SELECT ShouPingZT FROM XiangMuJBXX WHERE ShouPingZT LIKE '%HY%')
and PingJiJG.ZhuTiJB *= PF.BianHao
and PingJiJG.ZhaiXiangJB *= PF1.BianHao
and PF.PingJiFH = 'A+'本来默认查询是没有最后一行的,当有条件后,就会在最后一行加入那个a+的查询条件,这样就不行了。