Now, for a many-to-many relationship, you need that join table, but I don't see the need on basic one to one and one to many relationships.
Joined: Dec 11, 2006
I agree with your "I don't see the need..." statement, and yet this is what the specification says (from p. 9.1.24):
The default schema-level mapping for unidirectional one-to-many relationships uses a join table, as described in Section 18.104.22.168. Unidirectional one-to-many relationships may be implemented using one-to-many foreign key mappings, however, such support is not required in this release. Applications that want to use a foreign key mapping strategy for one-to-many relationships should make these relationships bidirectional to ensure portability.
Joined: Aug 03, 2002
Thanks for the help, but i guess i am looking for unidirectional without the join table.