Could somebody tell me what is it?
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Not Committed
General error;-710 Missing SELECT PARSID.
select T1."nums" || ':' || T2."nums" AS MINUT
,(select count(*) as cnt
from log l
where kod_ats=1 and l.dvnach between timestamp('2003-09-01','00:00:00') and timestamp('2003-09-01','23:59:59') and
l.dvnach between timestamp('2003-09-01',T1."nums" || ':' || T2."nums" || ':00') and timestamp('2003-09-01',T1."nums" || ':' || T2."nums" || ':59')) as cnt
from NUMS T1,NUMS T2
where 0<=T1."num" AND T1."num"<=23 AND 0<=T2."num"AND T2."num"<=59
order by t1."num",t2."num"
explain successefully shows execution plan for this query...
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
