hi divakar,
ojb does not support joining unrelated tables because the joins
are always built base on relationships defined in the repository.
you can use a QueryBySql which supports almost any sql-clause.
jakob
Sri Divakar schrieb:
Hi,
I am facing a problem of joining two unrelated tables using
queryByCriteria (reportQueryByCriteria).
For example:
Table T1{sno integer, id integer, desc varchar} and
Table T2{rollno integer, number integer, value varchar}
are two tables with out any relation between them (i.e., there are no
path-expressions in any of the class-descriptors).
I want to write a Query (QueryByCriteria/ReportQueryByCriteria),
which is equivalent to this SQL query:
SELECT T1.sno, T1.id, T1.desc, T2.value
FROM T1, T2
WHERE T1.id = T2.number
Thanks for any help/idea/comment/hint.
-Divakar
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
