http://nhforge.org/doc/nh/en/index.html#queryhql-select
select *elements(*p.Categories*)* from Product p where p.Brand = ? -Markus Am 13. Juni 2010 11:04:42 UTC+2 schrieb ubahn <[email protected]>: > Hi Markus, > > The problem is that each product can have more than one category and I > cannot query 'SELECT p.Category'. Is there something in HQL that can > handle such associations ? > > Mark > > On Jun 13, 7:30 am, Markus Zywitza <[email protected]> wrote: > > Why don't you use HQL for that, it is dead simple: > > > > select p.Category from Product p where p.Brand = ? > > > > -Markus > > > > Am 13. Juni 2010 06:43:28 UTC+2 schrieb Mark Borg <[email protected]>: > > > > > > > > > OK Guys, solved using a native SQL query > > > > > SELECT * FROM prod_productcategory pc > > > JOIN prod_productcategories pcs ON pc.id = pcs.productCategoryId > > > JOIN prod_product p ON pcs.productId = p.id > > > AND p.productBrandId = :productBrandId; > > > > > On Sun, Jun 13, 2010 at 5:57 AM, ubahn <[email protected]> wrote: > > > > >> Hi all, > > > > >> I have the following model: > > > > >> Each Product is linked with a ProductBrand > > >> Each Product has a HasAndBelongsToMany relationship with > > >> ProductCategory > > > > >> and what I`m trying to retrieve is a list of product categories for a > > >> given product brand if there are products linked with that brand > > > > >> Can someone give me a hand on this one .... > > > > >> Thanks > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "Castle Project Users" group. > > > To post to this group, send email to > [email protected] > > > . > > > To unsubscribe from this group, send email to > > > [email protected]<castle-project-users%[email protected]><castle-project-users%2Bun > [email protected]> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/castle-project-users?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected] > . > To unsubscribe from this group, send email to > [email protected]<castle-project-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
