Hi,
check ur UPDATE syntax .It shud b like ...

set tab_name
(column, column,...) = (subquery)

Akila Rajakumar