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

Reply via email to