[Reactor For CF] Reactor Joins

[Pallavi Naresh]

I'm trying to understand how to perform joins with Reactor. 

I have two tables, "Employee" and "Position".  "Employee" has a positionId that corresponds to the employee's position.  The "Position" table translates the positionID to a name (such as "Manager"). 

I want to display a list of all employees and their position.  I can see how I could create an Employee gateway, and then iterate over each employee and query for its PositionName.  This is somewhat tedious and inefficient.   It would be more efficient to perform a SELECT that joins the two tables. 

Is there a way to accomplish this with Reactor?
-- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/