最近做一个东西,查询数据库中,但是在SQL中验证查询语句,提示错误,还请各位给看下:
SELECT T1.POUND_NO,T2.POUND_NO AS RATE_POUND_NO,T1.POUND_TYPE FROM TDCJL06 T1,TDCJL06 T2 WHERE T1.POUND_TYPE <'6' AND T1.POUND_NO LIKE @POUND_NO||'%' AND T1.PROD_CNAME =NVL(@PROD_CNAME,T1.PROD_CNAME) AND T1.RATE_POUND_NO = T2.POUND_NO AND T2.WT_FLAG >= '1' AND T1.NET_WT_TIME >= @NET_WT_TIME_START AND T1.NET_WT_TIME <= @NET_WT_TIME_END ORDER BY T1.NET_WT_TIME DESC还请各位讲设计@%部分仔细看看,看我写的有没有错,另外还有红字部分,谢谢了
SELECT T1.POUND_NO,T2.POUND_NO AS RATE_POUND_NO,T1.POUND_TYPE FROM TDCJL06 T1,TDCJL06 T2 WHERE T1.POUND_TYPE <'6' AND T1.POUND_NO LIKE @POUND_NO||'%' AND T1.PROD_CNAME =NVL(@PROD_CNAME,T1.PROD_CNAME) AND T1.RATE_POUND_NO = T2.POUND_NO AND T2.WT_FLAG >= '1' AND T1.NET_WT_TIME >= @NET_WT_TIME_START AND T1.NET_WT_TIME <= @NET_WT_TIME_END ORDER BY T1.NET_WT_TIME DESC还请各位讲设计@%部分仔细看看,看我写的有没有错,另外还有红字部分,谢谢了
FROM TDCJL06 T1,TDCJL06 T2
WHERE T1.POUND_TYPE <'6' AND T1.POUND_NO LIKE @POUND_NO+'%' -->不用||,直接加
AND T1.PROD_CNAME =NVL(@PROD_CNAME,T1.PROD_CNAME)
AND T1.RATE_POUND_NO = T2.POUND_NO AND T2.WT_FLAG >= '1'
AND T1.NET_WT_TIME >= @NET_WT_TIME_START
AND T1.NET_WT_TIME <= @NET_WT_TIME_END
ORDER BY T1.NET_WT_TIME DESC
NVL 也要换成 ISNULL。