I am new at writing triggers
i am trying to write a trigger that has a update based on a select statement but nothing i do seems to work would appricate any help.

Function

begin
Update table
(
fields
)
(
Select SQL statement
)
return null

end;