[web2py] Re: A database design dillema

[villas]

I forgot that you need to add different tables,  try something like this 
instead...

a=db.auth_user.with_alias('a')
r1 = db(a.id==1).select(a.id)

a=db.auth_group.with_alias('a')
r2 = db(a.id==1).select(a.id)

rows_all = r1 & r2