G
GreySky
Generally speaking, ambiguous joins are caused by
inappropriately trying to mix inner joins with left joins
in the same query.
The solution is to create subqueries -- new queries --
that contain *only* the inner joins or *only* the left
joins. Then in a new query, use these subqueries.
The point is to have a query that doesn't inappropriately
mix inner- and left-joins.
If this is way off base, let me know.
David Atkins, MCP
inappropriately trying to mix inner joins with left joins
in the same query.
The solution is to create subqueries -- new queries --
that contain *only* the inner joins or *only* the left
joins. Then in a new query, use these subqueries.
The point is to have a query that doesn't inappropriately
mix inner- and left-joins.
If this is way off base, let me know.
David Atkins, MCP