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 conditions for example
select product.id , product.name, product.price , product.productgroupid ,
productgroup.name, productgroup.logo from product a inner join productgroup
b on a.productgroupid = b.id .
How can i do this with ojb 

thank in advanced ,
Regards 


--
View this message in context: 
http://www.nabble.com/inner-join-n%3A1-how-to-t1509312.html#a4094471
Sent from the Apache DB - ObjectRelationalBridge Users forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to