from子句里面能用select查询吗?
lt168 2003-06-30 08:51:27 select avg(b.a) from (select max(TO1OO) as a from ORG_BULL where STATID='003' and substring(ODATE,5,2)='05') b
上面SQL语句执行的时候出现以下错误:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Incorrect syntax near '('.
[INTERSOLV][ODBC SQL Server driver][SQL Server]Incorrect syntax near 'b'.
请问是什么回事呢,怎么解决?谢谢