Conflicts in Relationships
From: bill_dev <member38341_at_dbforums.com>
Date: Wed, 17 Sep 2003 19:16:50 -0400
Message-ID: <3383509.1063840610_at_dbforums.com>
Date: Wed, 17 Sep 2003 19:16:50 -0400
Message-ID: <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
-- Posted via http://dbforums.comReceived on Thu Sep 18 2003 - 01:16:50 CEST