这句在sqlserver中能运行,为什么在sybase中报错
garth 2002-12-10 09:04:31 SELECT tableno
FROM pos_tblsta
WHERE (regcode LIKE '10%') AND (tableno NOT IN
(SELECT pos_tblav.tableno
FROM pos_tblav,(SELECT tableno, max(begin_time) as times
FROM pos_tblav GROUP BY tableno) b
where pos_tblav.tableno = b.tableno AND
pos_tblav.begin_time = b.times AND
(pos_tblav.sta=7 or pos_tblav.sta=8)))
错误好像出在 (SELECT tableno, max(begin_time) as times
FROM pos_tblav GROUP BY tableno) b
这个地方,请问如何改。