relation ship and query

  • Thread starter Thread starter a
  • Start date Start date
A

a

How many table can I make relation between them in Query Design view?

Because this message appear to me after I add 3 table only

The SQL statement could not be executed because it contains ambiguous outer
joins. To force one of the joins to be performed first, create a separate
query that performs the first join and then include that query in your SQL
statement. (Error 3258)
 
You can add 32 tables in a query, but since you can query other queries, in
theory you could probably build as many as 992. I'm sure you'd run out of
memory way before that.

Your error message is being caused by the Outer Joins. To make is simple,
the arrows are pointing in different directions. The error message tells you
exactly how to fix the problem.
 
It's got nothing to do with the number of tables, it's because you've got
ambiguous outer joins, as indicated by the message. It *might* be possible
to change the query so that it works. For example, if table A is left
joined to table B, and table B is then inner joined to table C, it *might*
work if you used a left join from B to C instead of an inner join. In other
words, once you've used an outer join, make sure that any "downstream" joins
that you add are also outer joins pointing the same direction as the first
one.

Or, you could simply do what the message suggests: do one of your joins in
another query, and include that query in your main query.

If none of that makes any sense to you then you will need to post the SQL so
that someone can show you exactly what to do.
 
Back
Top