On Sat, Jan 31, 2009 at 03:45:38PM -0500, Michael LeSauvage wrote: > Keep in mind whilst reading this that I have essentially no SQL background.
You are welcome! > - 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. Yes, a new field, int FOREIGN KEY, is created in the table where the ForeignKey column is declared. MultipleJoin column is not a real column, but a mark for SQLObject to know what ForeignKey points to it. > - 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? Yes, there is a hidden table with two columns - two FOREIGN KEYs pointing to both tables. If you want to create the table yourself to control what is in the table, see http://sqlobject.org/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship Oleg. -- Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
