hi wallace,
it's not necessary to join manually, ojb will do it for you:
Criteria crit = new Criteria();
ReportQueryByCriteria q = QueryFactory.newReportQuery(A.class, crit);
q.setAttributes(new String[] {xxx, yyy, rel_b.zzz });
Iterator it = broker.getReportQueryIteratorByQuery(q);
there must be a relationship-definition from class A to B named 'rel_b' in the
repository.
jakob
Info wrote:
Hello,
I tried the following code to select a join, but get error:
Criteria crit = new Criteria();
crit.addEqualToColumn(A.xxx, B.xxx);
ReportQueryByCriteria q =
QueryFactory.newReportQuery(A.class, crit);
q.setAttributes(new String[] {A.xxx, A.yyy,
B.zzz });
Iterator it = broker.getReportQueryIteratorByQuery(q);
( In the case, for string A.xxx or B.zzz, what name should I use as
A or B? The physical table name or class name represented or other name?)
SQL statement:
SELECT A.xxx, A.yyy, B.zzz
FROM A JOIN B
ON A.xxx = B.xxx
Please help!
Thanks!
Wallace
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]