Say I have a parent table tblA and child table tblX:
db.define_table('tblA',
Field(fldA'))
db.define_table('tblB',
Field('fkA', db.tblA),
Field('name', 'integer'),
Field('data'))
How do I left join the two queries on tblB below:
1st: db(db.tblB.fkA == 1).select(db.tblB.name,db.tblB.data)
2nd: db(db.tblB.fkA == 2).select(db.tblB.name,db.tblB.data)
My intention is to generate the following fields:
name, data from first query, data from 2nd query
Since the two queries could result to a different set of names, I
would like ALL of the 1st query to be included in the result and
attached to each record will be matching data from the 2nd query, if
any.
