Updating a Table

[malaysarkar]

Team,

I am trying to update few columns of a table using other table.

Please find the query below. When I am excuting it I am getting an error" Query should be an updateable query"

UPDATE Outage_Details
SET Outage_Details.Final_Status = (Select Stafftime_Outages_Exceptions.Final_Status from Stafftime_Outages_Exceptions where Stafftime_Outages_Exceptions.Badge= Outage_Details.Badge);

Regards,
Malay

[pbmods]

Heya, Malay. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

Instead of a subquery, try using a join.

http://dev.mysql.com/doc/refman/5.1/en/update.html (look about halfway down the page)