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?



<a 
href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824901#3824901";>View 
the original post</a>

<a 
href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824901>Reply 
to the post</a>


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to