[web2py] return record from a query only shows field from one table

[António Ramos]

this
db(db.requests.product==*db.products.id*==3).select()

returns all field from *product* table only

this
db(db.products.id==*db.requests.product*==3).select()

  returns all field from *requests* table only


What is the logic?

and if i want all record from both tables?


thank you
António