How to show previous day values in query
- by Hakan
I am going to be crazy I think. Please Help.
I have a table which fields are Date, No, Turnover, TotalWin, Opencredit, Handpay, Billin, gamesplayed and I am trying to write sql in vb.net that will show me previous day value but I cant. Here is what I am trying to do.
SELECT Meter.*
FROM
Meter AS Previous,
Turnover As Prev_turnover
WHERE Date = '
SELECT Max(Date)
FROM Meter AS Previous2
WHERE Previous2.Date < Date
AND Previous2.No = ‘No'
AND Previous.No = ‘No’
What is wrong in where I am doing mistake I really don't know. If anyone help will be appreciated.
Thanks