Hi there,
I have three tables like this:
Pricelistsheet:
*row_id
*name
PricelistsheetItem
*row_id
*pricelistsheet
*product
*order
Product
*row_id
*name
Since PricelistsheetItem has several columns that can't be captured in a normal many-many relationship table, we've defined two many-one relationships to the two other tables
Now I would like to get a Collection of all the Products that belong to certain pricelistsheet.. I can't seem to get it to work.. What should my EJBQL look like?