|
Posted by Brian on 08/25/05 14:17
Hi all
I hope I can explain this properly.....
I'm trying to run a search on a MySQL table that checks if item
were out of stock between 2 dates and reports it
This is what it need to do
The fields are
timestamp = the timestamp to search on
status = the status code, 'o' if out of stock
ord = the number ordered
description = the item description
I need to say show me items between startday and endday that were out of
stock
and how many were ordered
e.g.
Item A = 400 ordered
Item B = 250 ordered
Item C = 100 ordered
What's the best way to do this without have vapours SQL queries?
Any help would be great
Brian
Navigation:
[Reply to this message]
|