Forum Moderators: open

Message Too Old, No Replies

Find rows for a value with different dates in the same table

Need a single query/subquery

         

dougmcc1

4:44 pm on Jan 22, 2008 (gmt 0)

10+ Year Member



Assuming the fields in a single table are Date¦Product¦Sales, I want to return all products that had fewer sales yesterday than the day before.

What would be the query for this?

Thanks in advance.

dougmcc1

5:04 pm on Jan 22, 2008 (gmt 0)

10+ Year Member



Also, how do I return the difference in sales, ordered by difference in sales descending?