Auto reply : Final solution done with normal SQL query.
Solution includes sub queries attribute as well. ++ On 3/22/06, Bruno CROS <[EMAIL PROTECTED]> wrote: > > > Hi again, > > I 'm desesperatly searching how to produce ReportQuery with a reflexive > virtual relation. > > Is it possible to declare an alias (useralias may be) (specially created > for ReportQuery may be) to obtain the matrix of a a table by itself. > > Imagine a ReportQuery as this > > attribute : p1, _LOOPBACK.p1 > class : Table.class > criteria : p2=_LOOPBACK.p3 > > this would be traduced by : > > select A0.p1, A1.p1 FROM table A0, table A1 where A0.p2 =A1.p3 > > Regards > > > > On 3/21/06, Bruno CROS <[EMAIL PROTECTED]> wrote: > > > > > > Hi all, > > > > first, thanks Armin for the patch, i think will wait 1.0.5 if it will > > be released in the month, because i need CLOB changes too. > > > > I'm asking me if it's possible to build an auto join ReportQuery such > > as : > > > > select A0.id <http://a0.id/>, A1.id <http://a1.id/> FROM table1 A1, > > table1 A2 where A1.joinColumn1 = A2.joincolumn2 > > > > Does anyone get to code this (using setAlias by example) > > > > Thanks > > > > >
