Re: Conflicts in Relationships
Date: Wed, 17 Sep 2003 22:49:42 -0400
Message-ID: <3383978.1063853382_at_dbforums.com>
I mean changing a left outer join into a right outer join... or I mean,
in the course of creating a query, the user adds a join of a type that
conflicts with the joins that are already configured.
E.g. Assuming a query exists like this....
SELECT TableA.*
FROM TableB INNER JOIN
TableA ON TableB.id1 = TableA.id1 INNER JOIN
..which is just 3 tables inner joined in a triangle. If the user then
tries to change the relationship between A and B to make sure all
records of A appear in the result, then the query builder software needs
to somehow report a conflict in the relationships because the
relationship between A and C must change as well.
I hope I explained that properly...
TableC ON TableB.id3 = TableC.id3 AND TableA.id3 =
TableC.id3
--
Posted via http://dbforums.com
Received on Thu Sep 18 2003 - 04:49:42 CEST