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]