[web2py] Can you filter a table before performing a join?

[monotasker]

I have a complex select() that would be much easier if I could do a left 
outer join between a db table and a rows object resulting from a previous 
db.select(). Is this possible?