Join Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have not used Access in a long time. I have a problem with a query and I
am wondering if it is because of the join type. No data is coming up in the
query. Let's say there are 5 tables. And all tables link to Table 1.

Is it correct to say in a inner join if there are is an entry in Table 1,
Table 3 and Table 4 because there is no data in Table 2 and Table 5 the query
would come up blank? I think i'm confused with concepts of inner join, left
join and right join.
 
Tami said:
I have not used Access in a long time. I have a problem with a query and I
am wondering if it is because of the join type. No data is coming up in the
query. Let's say there are 5 tables. And all tables link to Table 1.

Is it correct to say in a inner join if there are is an entry in Table 1,
Table 3 and Table 4 because there is no data in Table 2 and Table 5 the query
would come up blank? I think i'm confused with concepts of inner join, left
join and right join.
Click to expand...

Yes if all of your joins are inner (no arrows on the line) then a matching
record will need to exist in all five tables or else that join value will be
excluded from the output.
 
Tami,

Just to expand upon Rick's advice... So, if you changed all the joins
to Left Joins (the join lines in the query design window will show an
arrow head on tables 2-5), the query should then return all records from
Table 1, and any data from tables 2-5 where that table has an entry
matching the Table 1 data in the join field. Any clearer?
 
Back
Top