CODEWITHSUNDEEP
mysqlsql-updateinner-join
Peter Fulton
Peter Fulton

Reputation: 49

INNER JOIN UPDATE hanging on sending data

Trying to update one table from a column in another table based on two conditions. I've tried many version of this but this is what I'm currently trying and it just hangs. When I check the table while running, I'm not seeing any updating occurring. Is there something wrong with my syntax? Thanks!

UPDATE earningsdates e
INNER JOIN actualmove a 
ON e.ticker = a.theticker AND e.exactearningsdate = a.realearningsdate
SET e.theamove = a.themove;

Upvotes: 0

Views: 126

Answers (1)

Peter Fulton
Peter Fulton

Reputation: 49

I made ticker and theticker non-unique indexes and the query worked without a problem.

Upvotes: 1

Related Questions