Hi expert ,

I have a requirement to create a trigger to update the same table or subject table when some one inserted some new record /or update the record (the table contain one column

role if its -1 than it need to updated as 2 ) in subject table .

But as i know we can't update the same table using trigger .

So what should be the possible solution ?

Thanks,

Sumit