SELECT B.RIQI_DATE,A.DANJ_NO,C.SHANGP_NO ,B.SHOUH_STAFF
FROM SYN_HIS_YW_SJZL A,SYN_HIS_RK_KPD_HZ B,JC_SPZL C
WHERE A.DANJ_NO= B.DANJ_NO
AND A.SHANGP_ID=C.SHANGP_ID
AND B.SHOUH_STAFF IN
(SELECT DISTINCT ZUOY_STAFF FROM SYN_HIS_YW_ZYRYJL WHERE CAOZJS_ID IN
(SELECT JIAOS_ID FROM KH_JC_JSZD WHERE JIAOS_NAME IN ('入库收货组长','入库收货员')))
AND B.RIQI_DATE>=:BEGIN_RQ
AND B.RIQI_DATE<:END_RQ + 1
AND B.SHOUH_STAFF LIKE NVL(:SHOUH_STAFF,'%')
GROUP BY B.RIQI_DATE,A.DANJ_NO,C.SHANGP_NO, B.SHOUH_STAFF
语句如上,我现在想查询一下,SHOUH_STAFF是姜倩倩,BEGIN_RQ是2010/9/19,END_RQ是2010/9/21,请问,我该怎么将数值代入到语句中进行查询?在此谢过各位。
------解决方案--------------------
对应几个绑定变量就行了