"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 Wed Sep 17 2003 - 19:24:26 CDT
