求简单的触发器问题
我有一张表a
id name pwd sum uid
001 ss 123 100 1
002 ww 11 200 2
002 qq 22 100 3

b
uid uname
1 rr
2 tt

然后create table c as
(select a.id, a.name, a.pwd, a.sum, a.uid,b.uname from a left jion b on a.uid=b.uid )

创建好的c表结构如下
id name pwd sum uid uname

c表建好之后，想做一个触发器，当向a表中插入或者更新一条记录时，
就在c表中增加一条记录。
求个具体写法。


[解决办法]
仅供参考：

SQL code

create or replace trigger AutoInsert_A after insert or update on a REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROWbegin    insert c     select new.id,new.name,new.pwd,new.sum,new.uid,b.uname    from a left jion b on new.uid=b.uid end AutoInsert_A ;
[解决办法]
http://topic.csdn.net/u/20081203/20/787d9749-33d4-4561-ac66-eb37488cd1e5.html