Hi,
I would want to know if the common table expression exist in maxdb, and as I
can use them. the clause with does not work in SQL studio.
WITH B(id, start)
AS(
SELECT id, start
FROM ANNOTATION
)
SELECT *
FROM B
I use
DECLARE C CURSOR FOR
WITH RECURSIVE.....
for recursive query!! but I'have need of simple common table experession
(cte), or more cte in a single query.
thanks
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Solo 10 Euro per chiamare in tutto il mondo!! Scopri il vantaggio di Email
Phone Card, clicca subito
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2685&d=20060218
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
