correction: record=db().select(db.Book.ALL, db.Union.ALL, left=db.Book.on(db.Union.book_id<>db.Book.id))
i use 'left=db.Book.on' not 'right=.....' On 4 Giu, 14:17, 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
