Dear Friends,

I'm not sure what is wrong with the following query.

update mast_1 set (SELECT_CLAUSE, FROM_CLAUSE, WHERE_CLAUSE, GROUP_BY_CLAUSE, HAVING_CLAUSE) = select (SELECT_CLAUSE, FROM_CLAUSE, WHERE_CLAUSE, GROUP_BY_CLAUSE, HAVING_CLAUSE) from MAST_2 where work_id = 1234;


If this query is wrong, pls give me corrected or equivalent query.

Thanks,
Kayal.

have yoy tried the query or tried to analyze the query ?
what is the error message ?
have you tried to qualify the column names ?
where work_id = 1234 -- does this belong to the update or to the select mast_2 ?
"pls give me corrected or equivalent query. " -- we provide hints/tips : no solution