I think you want this, all Books without a union. records=db(~db.Book.book_id.belngs(db()._select(db.Union.id))).select(db.Book.ALL)
On Jun 4, 7:17 am, ceriox <[email protected]> wrote: > hi all > i have a problem making an outer join > somebody can write me the correct one? > > db.define_table('Union', > Field('user_id', db.User, writable=False, readable=False), > Field('book_id', 'integer', db.Book, writable=False, > readable=False)) > > db.define_table('Book', > Field('Titolo', 'string')) > > i want to have all book with no User > i try with > record=db().select(db.Book.ALL, db.Union.ALL, > right=db.Book.on(db.Union.book_id<>db.Book.id)) > > but i have all Book and Book without union > > what is the error? > thanks for help
