为什么这条select语言不对?
SELECT SUM(AMT) AS AMT,left(time,2) AS TIME11 FROM RETAIL WHERE DATE=date() ;
ORDER BY time11 GROUP BY time11
我是用vb编程的,打开的是dbf数据库!!
SELECT SUM(AMT) AS AMT,left(time,2) AS TIME11 FROM RETAIL WHERE DATE=date() ;
ORDER BY time11 GROUP BY time11
我是用vb编程的,打开的是dbf数据库!!
SELECT SUM(AMT) AS AMT,left(time,2) AS TIME11 FROM RETAIL WHERE DATE=date() ;GROUP BY time11 ORDER BY time11
把后面的amt换一个名称试试
SUM(AMT) AS AMT1