SPT SQL查询出错
有三张表,CURRENTSTOCK,WAREHOUSE,INVEVTORY CURRENTSTOCK:CINVCODE,CWHCODE,IQUANTITY;WAREHOUSE:CWHCODE,CWHNAME;INVEVTORY:
CINVCODE,CINVNAME;现在组合成CURRENTSTOCK.CINVCODE,INVEVTORY.CINVNAME,WAREHOUSE.CWHNAME,CURRENTSTOCK.IQUANTITY ,使用下面的
SQLEXEC(gnConnHandle,"SELECT CURRENTSTOCK.CINVCODE,INVEVTORY.CINVNAME,WAREHOUSE.CWHNAME,CURRENTSTOCK.IQUANTITY FROM CURRENTSTOCK,WAREHOUSE,INVEVTORY WHERE CURRENTSTOCK.CINVCODE=INVEVTORY.CINVCODE.AND.WAREHOUSE.CWHCODE=CURRENTSTOCK.CWHCODE","ord125")
SELECT ord125
报错: ord125 not found
请教是什么原因阿?