creating trigger

Hey!

I have two tables as illustrated below:

people

name| #houses
------|-----------
a | 3
b | 5
c | 9

rich
name| #houses
------|-----------
w | 13
f | 19
g | 11

I need to create a trigger to insert a tuple of the people table into the rich every time the update of the people table causes someone's no. of houses to go above 10.
Please help me with the code.

write a update trigger on People table.
apart from other syntaxes:
insert into rich (name,houses) values (update.name,update,houses) where update.houses>10

Let me know if it works for you.

cheers!!!
Vatsa
www.objectiveprogramming.com