[SQLObject] Rudimentary question

[Michael L. <the...@gm...>]

Keep in mind whilst reading this that I have essentially no SQL background.
While I am interested in learning about it, I have been searching
documentation and tutorials about SQLObject to no success.

My questions are:

   - When I use a MultipleJoin/Foreign Key relationship between two tables,
   are any columns or tables created to support this relationship?  I suspect
   that this is simply a nice way of hiding a select query.
   - When I use a RelatedJoin relationship between two tables, what happens
   at the SQL level?  I think an intermediate table is created.  What's in this
   table?

All help is much appreciated.  If you have a reference on the web to point
me at, I'm quite happy to read; I just haven't been able to find the answers
myself.


Mike