2 Replies Latest reply on Nov 13, 2017 12:58 PM by Shawn Uhlinger

    How to join tables using date criteria

    Shawn Uhlinger

      Newbie here, having trouble joining tables.  I need to know how many sales are made by people in each job type, but a single person's job type can change over time, so I want to match the record with the job type corresponding to the date of the sale.  I have two tables:  Sales and People.  The Sales table has order number, salesperson id and other information about the sale.  The People table has salesperson id, job type, start date, end date.  How do I create a join to pull in all the sales and give me the job type of the person who sold each?  TIA