Member Avatar for kayak_186 
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

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 3 Contributors
  • 4 Replies
  • 149 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by kayak_186

Recommended Answers

All 4 Replies

Member Avatar for debasisdas

What is not working ?
Are you getting any error ?

Check if your sub query returns any record.

Member Avatar for anand01

hi kayak_186,
whats output you getting?

Member Avatar for kayak_186

hi, anand01, debasisdas.

I'm getting error:
Error Code : 1093
You can't specify target table 'companystatistic' for update in FROM clause

Member Avatar for kayak_186

thanks all,
I fixed problem..

update companystatistic
set ReferencePrice = ( select ClosedPrice
from (Select * from companystatistic) as X
WHERE CompanyID= 310 and ResultedDate = CURDATE() - 1
)
where ResultedDate = CURDATE()
and CompanyID= 310

hihi.. It's working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.