下面是查询or语句,再想增加一个根据传入的bh条件查询,就是判断传入参数str值截取,从bh左侧截取到传入str参数的长度,请问该如何写?我是用Delphi开发的left(bh,len(:str))=:str
SELECT a.yppinming,a.bh,a.idno,b.jhdanwei, ISNULL(b.ypshuliang, 0)
AS ypshuliang
FROM (SELECT bh,yppinming,idno FROM Y_baseinfo
where (yppinyinma LIKE :pinyinma and ypflag='是' ) OR (yppinming LIKE :yppinming and ypflag='是') OR (yphuaxuemingcheng LIKE :ypbianma and ypflag='是')
GROUP BY bh,yppinming,idno) a LEFT OUTER JOIN
(SELECT ypid,jhdanwei, SUM(ypshuliang) AS ypshuliang
FROM Y_kucun
GROUP BY ypid,jhdanwei) b ON a.idno = b.ypid
GROUP BY a.bh,a.yppinming,a.idno, b.jhdanwei,b.ypshuliang
SELECT a.yppinming,a.bh,a.idno,b.jhdanwei, ISNULL(b.ypshuliang, 0)
AS ypshuliang
FROM (SELECT bh,yppinming,idno FROM Y_baseinfo
where (yppinyinma LIKE :pinyinma and ypflag='是' ) OR (yppinming LIKE :yppinming and ypflag='是') OR (yphuaxuemingcheng LIKE :ypbianma and ypflag='是')
GROUP BY bh,yppinming,idno) a LEFT OUTER JOIN
(SELECT ypid,jhdanwei, SUM(ypshuliang) AS ypshuliang
FROM Y_kucun
GROUP BY ypid,jhdanwei) b ON a.idno = b.ypid
GROUP BY a.bh,a.yppinming,a.idno, b.jhdanwei,b.ypshuliang
解决方案 »
- Delphi多层分布式架构QuickBurro再上一层楼
- delphi中如何统计多行文本文件中相同字符串出现的次数?
- V死它呀~~比尔该死呀~
- 函数返回问题!--高分征解
- 接口编程 Interface如何转换成类变量
- 在主窗口有个‘退出系统’BUTTON,然后点击,会弹出一个FORMCLOSE,FORM里有3个BUTTON,
- 請問一下把三層的應用層移到另外一台服務器上去該做些什么工作?
- adoquery问题,高手请进
- 高分赠送,简单问题
- MIDLETPascal 有谁知道怎么使用,或者到哪里有这方面的资料
- delphi7安装DSPACK问题
- 小女求助!delphi ini配置文件存放路径设置问题~~~求助!!
AS ypshuliang
FROM (SELECT bh,yppinming,idno FROM Y_baseinfo
where (yppinyinma LIKE pinyinma+'%' and ypflag='是' ) OR (yppinming LIKE yppinming+'%' and ypflag='是') OR (yphuaxuemingcheng LIKE ypbianma+'%' and ypflag='是')
GROUP BY bh,yppinming,idno) a LEFT OUTER JOIN
(SELECT ypid,jhdanwei, SUM(ypshuliang) AS ypshuliang
FROM Y_kucun
GROUP BY ypid,jhdanwei) b ON a.idno = b.ypid
GROUP BY a.bh,a.yppinming,a.idno, b.jhdanwei,b.ypshuliang
這樣試試
AS ypshuliang
FROM (SELECT bh,yppinming,idno FROM Y_baseinfo
where (yppinyinma LIKE @pinyinma+'%' and ypflag='是' ) OR (yppinming LIKE @yppinming+'%' and ypflag='是') OR (yphuaxuemingcheng LIKE ypbianma+'%' and ypflag='是')
GROUP BY bh,yppinming,idno) a LEFT OUTER JOIN
(SELECT ypid,jhdanwei, SUM(ypshuliang) AS ypshuliang
FROM Y_kucun
GROUP BY ypid,jhdanwei) b ON a.idno = b.ypid
GROUP BY a.bh,a.yppinming,a.idno, b.jhdanwei,b.ypshuliang
:pinyinma--是變量?
left(bh,len(:str))=:str
直接:
bh like :str+'%'