[web2py] Worked with joined data

[pbreit]

Is there some way to work with joined data like this?

rows = ((db.item.status=='active') &
            (db.item.created_by==db.auth_user.id)).select()
return (rows=rows)

{{for item, user in rows.item, rows.auth_user:}}
    {{=item.id}} by {{=user.first_name}}
{{pass}}

I'm not sure if it's possible or how to do this part:

     {{for item, user in rows.item, rows.user:}}