Hi,
If I have OrderLines and Product table (Product.class) for the following classes and only the specified attributes are declared in the hibernate mapping, can I create a query like
"select qty, productName from OrderLine, Product where Product.pruductId = 10" without declaring any Collection attribute in any of the classes? I've seen in the reference something like "select new list(mother, offspr, mate.name)
from DomesticCat as mother
inner join mother.mate as mate
left outer join mother.kittens as offspr" but don't know how to implement.


OrderLine
orderLineId
productId
qty

Product
prductId
productName

TIA,
iduniq

select o.qty, p.productName from OrderLine o, Product p where p.pruductId = 10


OrderLine needs a Product property, not a productId