Hi, Graham, > Am I doing something wrong in the following code? > > criteria.addJoin(BPeer.POLICYDETAIL_ID, > APeer.POLICYDETAIL_ID); > criteria.addDescendingOrderByColumn(BPeer.UNDERWRITING_YEAR); > criteria.addDescendingOrderByColumn(APeer.POLICYDETAIL_ID); > APeer.doSelect(criteria);
I think the issue is that when you ask APeer to select, it will select only the fields from a; it's telling you that you can't ORDER BY b.underwriting_year because that is not one of the columns in a. You could specify with addSelectColumn() exactly which columns you want to select and use BasePeer.doSelect() instead of APeer.doSelect, but that will give you com.workingdogs.village Records rather than a's, if that matters. Peace, --Carl --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
