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]
