Hello Jen,
To find out how to be able to specify joins or any SQL in custom finders, read:
http://www.orionserver.com/docs/orion-ejb-jar.xml.html
Search for query and look at the partial attribute.
What you want is already possible, without changing the code of your beans.
Regards,
Karl
How about having your Product company finder query to be
"SELECT * FROM Product WHERE Product.company = (SELECT Company.id FROM Company
WHERE Company.name LIKE ?"
I understand that this query may not be identical to the query you provided. But my
point is it is possible.