Adding additional data to a list of items

I am trying to create a report of inventory items and link sales history to the items. In one table I have all the items. In two other tables I have 30 day sales history and 90 day sales history data for the items that exist in the original list. I would like to add the sales history to the list of all the items. My linking of the items results in just those items with sales history however. I suspect that I am overlooking a simple way to keep the original list in tact and add the sales history to the items for which there is data.

Thanks for your help.

TechRickHave you tried using an outer join?|||Originally posted by proverbs53
Have you tried using an outer join?

Thanks! I'm glad it was that simple. Thanks for pointing the way!

Regards,
TechRick