2006/2/18, F.mangiacrapa <[EMAIL PROTECTED]>: > Hi, > > a question, but "inline view" > > SELCT * > > FROM ( > > SELECT id, start > > FROM ANNOTATION > > ) B > > > > > > and > > DECLARE C CURSOR DECLARE C CURSOR FOR > WITH RECURSIVE.... > > > they can be present in the same query?
I'm sorry I don't understand. AFAIK a cursor declaration can never be part of a query. > I have of the paths in the graph to find!! from an anchor to an other (with > recursion) > and through join between adjacent anchor! There is usually no way to make this happen with standard SQL - unless you're on Oracle and use CONNECT BY. I'm not sure what exactly you want to do here. Regards robert > thanks > > Francesco > > > > > > --------- Original Message -------- > Da: Robert Klemme <[EMAIL PROTECTED]> > To: > Cc: maxdb@lists.mysql.com > Oggetto: Re: WITH common table expression!! > Data: 18/02/06 11:43 > > > > > > > 2006/2/18, F.mangiacrapa <[EMAIL PROTECTED]>: > > > 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 > > > > Does this help? > > > > SELCT * > > FROM ( > > SELECT id, start > > FROM ANNOTATION > > ) B > > > > It's called "inline view". > > > > Kind regards > > > > robert > > > > -- > > Have a look: http://www.flickr.com/photos/fussel-foto/ > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f > > Sponsor: > Grande Offerta di Benvenuto Cassine di Pietra: > 36 bottiglie di ottimo vino veneto direttamente a casa tua! > > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3923&d=20060218 > > > -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
