Re: inner join n:1 how to

2006-04-28 Thread Armin Waibel
Hi, [EMAIL PROTECTED] wrote: Normally , if i use QueryByCriteria q = QueryFactory.newQuery(ProductImpl.class, criteria); and criteria contained some ProductGroup conditions ; and then i will retrieve all data of ProductImpl that product table outter join with ProductGroup table . May be in this

Re: inner join n:1 how to

2006-04-27 Thread [EMAIL PROTECTED]
Normally , if i use QueryByCriteria q = QueryFactory.newQuery(ProductImpl.class, criteria); and criteria contained some ProductGroup conditions ; and then i will retrieve all data of ProductImpl that product table outter join with ProductGroup table . May be in this case i HAVE to use ReportQuery

inner join n:1 how to

2006-04-25 Thread [EMAIL PROTECTED]
I have two classes Product(table=product) and ProductGroup(table=productgroup) ; these two tables are n:1 relationship means 1 row on productgroup may has more than 1 rows on 'produc' table . I want to query to get all fields of product table and 2 field of productgroup table with some