> > So pretty much no subqueries (ok somebody is going to say that any query > entailing a subquery can be rewritten without one) but AFAIC the language > you are talking about isn't really SQL then.
That someone can come to me and I’ll show him/her gazzilions of nested queries that cannot be unnested (SQL and/or XQuery). In fact, the ones you CAN unnest are pretty rare….. (I think I listed ALL of unnestable cases of XQuery here if I remember correctly…there are not that many…. http://dl.acm.org/citation.cfm?id=1315537 ) Not even the simplest form: for in for in … cannot always be unnested in most cases if I remember correctly …. Best Dana _______________________________________________ [email protected] http://x-query.com/mailman/listinfo/talk
