I need some help for my problem. Problem : I have following tables 1. Location : id, name, code 2. Product id, name, code, location ( ref to location table) 2. Product_Move id, product_id ( ref to product table), source_location (ref to location table) , destination_location ( ref to location table) , datetime ( date when move is created)
now i want to know for given period of dates, where is the product actually.