Query from multiple tables

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I have a productivity query that pulls from 9 tables. I've established
common relationships between all the tables. For some reason the query does
not return any info. Any suggestions as to what I'm doing wrong?
 
Barring anything in the WHERE clause that totatlly prohibits records being
returned, thus it is truely a relationship issue, then the thing to look for
is where an outer join should be used, rather than an inner.

Try switching any links (in the query vice the relationship window) between
the main table and any lookup tables to be outer joins. The link will change
from a line to an arrow, where the arrow should point to the lookup table.

main table -----> lookup table.
 
I have a productivity query that pulls from 9 tables. I've established
common relationships between all the tables. For some reason the query does
not return any info. Any suggestions as to what I'm doing wrong?
Click to expand...

If you're using the default INNER JOIN then you will only see results if there
is matching data in every single one of the nine tables. A nine-table join
query would be unusual (except perhaps as the basis for a Report); it's almost
certainly not going to be updateable if that's what you expect!

If there are tables which might have no matching data, select the join line to
that table in the Query and select option 2 or 3 - "show all data in <table1>
and matching data in <table2>". The fields in the missing-data table will just
be NULL.
 
Back
Top