SQL Join

[Michael Irving <mi...@keynetx.com>]

I'm trying to figure out how to setup a join with findAll or
findByCondition.  Essentially, the query I want to do is something like:

SELECT col1, col2
  FROM WorkOrderItemFulfillment wf
      ,WorkEfforts we
  WHERE we.workeffortId = wf.workeffortId
    AND wf.workEffortParentId IS NULL;


Can someone point me in the right direction?

Thanks