John McNally wrote:
>
> I think this can be solved two ways. If you are selecting
> ProjectPeer.PROJECT_ID, the join should be automatic, so I assume you are
> not selecting it. You can either add it to the select columns or try
Will BasePeer do the joins if each scarab table is in its own map?
>
> selectCriteria.add("forcing a join", (Object)(ProjectPeer.PROJECT_ID + "=" +
> ProjectVisitorPeer.PROJECT_ID), Criteria.CUSTOM );
>
> A bit ugly, but currently, this is the way to get any sql you want into the
> where clause.
SqlExpression.buildInnerJoin?
~Eric
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
