Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Southern California
    Posts
    35

    Question Unanswered: 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.

    TechRick

  2. #2
    Join Date
    May 2003
    Location
    Amsterdam, the Netherlands
    Posts
    4

    Outer join

    Have you tried using an outer join?

  3. #3
    Join Date
    Aug 2002
    Location
    Southern California
    Posts
    35

    Re: 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •