I have a Products table and a Movements table. I want to extract the latest movements table record for each Products record and I am unsure how to do it
I would like to return one line for each product:-
Products.Code, Products.Description. MOvements,Id, Movements,Date, Movements.Qty
showing only the most recent movement for each product.