I have a inventory Table with a list of item numbers.
I also have a sales table showing all sales. The following field are in the sales table
Quantity
DateSold
ItemNum
CustomerName
I need a to show all the items of the inventory table together with the last record of the sales table. So for each item a only need the last sale.
How can i create such a query?
Thanks for your help.
