Re: Conflicts in Relationships
Date: Wed, 17 Sep 2003 20:24:26 -0400
Message-ID: <Ol8ab.146$NJ6.12191800_at_mantis.golden.net>
"bill_dev" <member38341_at_dbforums.com> wrote in message
news:3383509.1063840610_at_dbforums.com...
>
> I'm looking for a loose algorithm, not code but is there a way in a
> query building scenario to determine if relationships in a SQL FROM
> clause are in conflict without actually executing the SQL?
>
> For example, 3 tables may be joined in a triangle and changing the
> direction of one join may invalidate the other relationships. Many
> commercial query builing interfaces seem to accomplish this (like MS SQL
> Server) although I don't need all the extra functionality they provide
> (like automatic conflict corrections etc...). Thx...
What do you mean by "changing the direction" ? Joins are symmetric. Received on Thu Sep 18 2003 - 02:24:26 CEST