On 11/23/05, Patrick Casey <[EMAIL PROTECTED]> wrote: > > > Ok, I admit it, this is probably a stupid question, but I can't > (curiously) seem to find an answer to this in the SQL spec. > > > > Is it legal for a child table (the n side of a 0..n) > relationship to have a foreign key relationship to *more than one* parent > table?
I'm not sure if this could help you but if you are used rather writing code, you may try to model all your data as Java object and use Hibernate + hibernate tools to generate your schema. I think it would do a nice job especially concerning all relational stuff. SQL is sometimes quite unfriendly. Thanks, Henri. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
