I do not understand. Can you make and example why actual data?
On Sep 3, 3:37 am, Noel Villamor <noe...@gmail.com> wrote:
> 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.
