update companystatistic
set ReferencePrice = (select ClosedPrice from companystatistic WHERE CompanyID= 310 and ResultedDate = CURDATE() - 1)
where ResultedDate = CURDATE()
and CompanyID= 310
I have a same code. But it's not work..
help me..!
thanks all