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