OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
WITH common table expression!!

From: F.mangiacrapa (f.mangiacrapaemail.it)
Date: Fri Feb 17 2006 - 18:31:39 CST

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