Hi,

For now I need to merge these three queries, Please let me know if there is a way to accomplish this.

UPDATE A

SET A.ACTION1=B.ACTION

FROM TABLE_A A,TABLE_B B

WHERE A.ID=B.ID AND A.ACTION1 IS...

There are only three kind of actions taken on any ID, and business wants to have all the history action that was taken on any particular ID. So here we...

Thank you so much for your help, yes it worked for me.