Joining unrelated tables

[Sri Divakar]

 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.