From what I understand, which may be wrong as always ;), is..

sql: select book.* from author, book where author.id=book.authorid_id and author.name='bob'

oo-sql: select author.books from author where author.name = 'bob'