Hi All, 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. can anyone help me ?? Thanks, Dhaval -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql