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.