I have a price table entered more than once every day,
In the report for spesific day, I must show also the last entered price for the
day before
The problem is that the day before sometimes varies not fixed
(if it is fixed I could just round down the required date substract the date
with 86400 to get
previous day)
How can I get the previous date
ID DATE ProductName PRICE Last
01 1/1/04 ProductABCD 1500 NO
02 1/1/04 ProductABCD 1600 YES
03 1/2/04 ProductABCD 1000 NO
04 1/2/04 ProductABCD 1100 YES
05 1/4/04 ProductABCD 1900 NO
06 1/4/04 ProductABCD 1800 NO
Report required for ‘1/4/04’
Previous Price : 1100 (ID: 04)
05 1/4/04 ProductABCD 1900 NO
06 1/4/04 ProductABCD 1800 NO
How do I Get 1100?
__________________________________
Do you Yahoo!?
Send a seasonal email greeting and help others. Do good.
http://celebrity.mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
