Re: Conflicts in Relationships

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

            TableC ON TableB.id3 = TableC.id3 AND TableA.id3 =
            TableC.id3

..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...

--
Posted via http://dbforums.com