<name>findByCatalogItemIDByUnitIDByRetailerID</name>
<query>,price_list_level
WHERE catalog_item_id={0}
AND catalog_item_unit_id = {1}
AND price_list.price_list_level_id = price_list_level.price_list_level_id
</query>
<order>price_list_level_default, unit_quantity DESC</order>
</finder>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John Moore
Sent: Thursday, June 07, 2001 2:35 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Problem with Custom finders ....
if you use a join you have to make sure that it is handled in a subselect since, I don't believe, you can modify the from clause in EJB 1.1 CMP. Here is an example of an where we join between two tables.
<finder>
<name>findExternalOrganizations</name>
<query>account_no_in = {0} and ounit_parent_no_in is null and ounit_no_in != ( select ounit_no_in from account_tbl where account_no_in = {0} )</query><order />
</finder>-----Original Message-----
From: Grim Shieldsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 10:06 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Problem with Custom finders ....
No I didn't, under Bean Managed Persistence. You do under CMP.
--- Ray <[EMAIL PROTECTED]> wrote:
> Hi again .... :-)
>
> Still working on my problem with customer finders
>
> Has anyone got an example of a cusotmer finder that
> uses SQL joins? This appears to be my problem.
>
> Did you have to define entity beans for the
> intermediate tables?
>
> Any examples would be much appreciated .... :-)
>
>
>
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
=====
Grim Shieldsson (James A Barrows)
Acting Chieftain of Clan StormWolf
Barbarian Freehold Alliance
Oppurtunity doesn't knock. It only presents itself after you kick down the door.
--Kyle Chandler__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user