SQLContainer referencing another container


I’m complete Vaadin newbie and I’m trying to wrap my head aroud SQLContainer.
Say I have Authors and Books and as there is an m:n relationhsip between them there are three tables in db:
authors, books and a relationship table calles authorship.
How can I express this with SQLContainer?
If I have an Item representing an author how do I get all the books he wrote?

Thank you,