I am trying to track price changes on a daily basis. I have 2 tables
NOTE: storeid in Prices is a reference to s_id in Stores
What I would like to do is run a query to find all prices from yesterday and compare them to today to see if they have changed. Please understand that I am filing in for the database admin for any advice you can offer.