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]



Reply via email to