How to include all records from table after Join?

[lfrjoan]

Hi all, i have something like this;

WeekNumber ---- TagsIssued
201019 ---- 196
201020 ---- 4
201021 ---- 1
201022 ---- 1
201024 ---- 16

TagsRemovedDate ---- TagsRemoved
201019 ---- 182
201021 ---- 3
201022 ---- 1
201023 ---- 1
201024 ---- 90

I want to merge WHERE TagsIssuedByWeek_Red.WeekNumber = TagsRemovedByWeek_Red.TagsRemovedDate

but the end product looks something like this

WeekNumber ---- TagsIssued ---- TagsRemoved
201019 ---- 196 ---- 182
201021 ---- 1 ---- 3
201022 ---- 1 ---- 1
201024 ---- 16 ---- 90

(notice week 201020 from TagsIssued and 201023 from TagsRemoved is gone)

My SQL looks something like this;

SELECT TagsIssuedByWeek_Red.WeekNumber, TagsIssuedByWeek_Red.TagsIssued, TagsRemovedByWeek_Red.TagsRemoved
FROM TagsIssuedByWeek_Red, TagsRemovedByWeek_Red
WHERE (((TagsIssuedByWeek_Red.WeekNumber)=[TagsRemovedByWeek_Red].[TagsRemovedDate]));
 

Could you please help me merge the 2 tables without losing rows? Thanks a million! =)

[Rabbit]

You will need to use a full outer join to get all records from both tables.

[lfrjoan]

Thanks =)
found my answer here in case anyone needs

http://www.databasejournal.com/featu...oft-Access.htm