[web2py] Re: Left joining two queries

[Noel Villamor]

TABLE db.tblB
fkA, name, data
1,100,'aaa'
1,101,'bbb'
1,102,'ccc'
2,100,'xxx'
2,101,'yyy'

1st query: db(db.tblB.fkA == 1).select(db.tblB.name,db.tblB.data)
name,data
100,'aaa'
101,'bbb'
102,'ccc'

2nd query: db(db.tblB.fkA == 2).select(db.tblB.name,db.tblB.data)
name,data
100,'xxx'
101,'yyy'

Desired left join result:
100,'aaa','xxx'
101,'bbb','yyy'
102,'ccc',None

I could do this in SQL but I do not know how to use aliases in web2py.
Thank you for the replies Massimo and pbreit.