0 Replies Latest reply on Mar 9, 2004 8:16 AM by aquila125

    ejbql question

    aquila125

      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?