I would also like to find the answer to this questions. I'm finding I'm executing 3 or 4 queries just to get the data I want. Maybe there is an easy way to map one object to multiple tables and still execute only once? I know I could write an SQL statment to do this, I'm just not certain how to do it in OJB.
Any Ideas? Graham -----Original Message----- From: Frank Renaers [mailto:[EMAIL PROTECTED]] Sent: August 28, 2002 12:44 PM To: '[EMAIL PROTECTED]' Subject: join Hi, In a report, I want to show information from 2 business objects. There 's a 1-n relationship between the 2 objects. ex. A category or productgroup can contain n articles and each article belongs to 1 productgroup For performance reasons, I want to select the report data with 1 sql. ex. select category.categoryname, article.articlename from category, article where category.category_nr = article.category_nr Does someone know whether this is possible with a ReportQuery ? Does someone have an example ? Thanks, Frank Renaers -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
