MS Access, Again
24 May 2004, 03:01 AM
#1
Scooby Regular
Thread Starter
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like
on
1 Post
MS Access, Again
Getting there, albeit slowly.
I have a two tables (Table C1 and Table C2).
(structure of both tables is [name] [id nbr] [value]
value in C1 is Fiscal Year 04 and value in C2 is Fiscal Year 05
I also have one query (Query Z), that attempts to join them.
The Problem;
it only joins items with values in both FY04 & FY05.
Any item with zero is either FY is ignored.
But I want to show zero in the respective column.
The db is tiny at 485 bytes, as it is a test db.
I can send on e-mail.
Ta.
I have a two tables (Table C1 and Table C2).
(structure of both tables is [name] [id nbr] [value]
value in C1 is Fiscal Year 04 and value in C2 is Fiscal Year 05
I also have one query (Query Z), that attempts to join them.
The Problem;
it only joins items with values in both FY04 & FY05.
Any item with zero is either FY is ignored.
But I want to show zero in the respective column.
The db is tiny at 485 bytes, as it is a test db.
I can send on e-mail.
Ta.
24 May 2004, 08:39 AM
#2
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
Its because the standard JOIN you are performing is an INNER join which will only show matching results from both tables. Look up in the help about a LEFT OUTER JOIN which will show results for both matches and non-matches.
Gary
Gary
Thread
Thread Starter
Forum
Replies
Last Post