Re: How to generate sub queries

2009-11-26 Thread andrew cooke
2009/11/26 Rainer Döbele : > > P.S. What Andrew suggested can be useful for self-joins. oops. sorry :(

re: How to generate sub queries

2009-11-26 Thread Rainer Döbele
with the distribution (empire-db-example-advanced). See function querySample(...) in SampleAdvApp.java. Hope this helps. Regards Rainer P.S. What Andrew suggested can be useful for self-joins. Gunnar Gr-Hovest wrote: > re: How to generate sub queries > > Hi, > > I would like t

Re: How to generate sub queries

2009-11-26 Thread andrew cooke
Hi, If I remember correctly, you need to use table.clone() to make a new copy of the table with a different alias, then use that in the subquery. Andrew 2009/11/26 Gunnar Gr-Hovest : > Hi, > > I would like to know to which extent sub queries in the FROM part of an > SQL statement are currently