Re: Conflicts in Relationships

The software would need human intelligence. Maybe the single "reversal" is what is needed to be done to get the "correct/desired" results. How would the software be able to interpret the semantics of the data/query?

"bill_dev" <member38341_at_dbforums.com> wrote in message news: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
>
> 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
Received on Thu Sep 18 2003 - 15:52:54 CEST