触发器两错误，求解

[dongliang_lu]

create trigger sss on pod_det
for insert
as
if inserted.pod_itmnbr='aaa'
begin
insert into temp02(pod_ponbr,itm_itmnbr,rqu_num)values(select a.pod_ponbr,b.itm_itmnbr,
b.mlot*((a.num/b.mlot)+1) from inserted a left outer join itm_det b on a.pod_itmnbr=b.itm_itmnbr);
end


select * from pod_det
select * from itm_det
select * from temp02


消息 156，级别 15，状态 1，过程 sss，第 6 行
关键字 'select' 附近有语法错误。
消息 102，级别 15，状态 1，过程 sss，第 7 行
')' 附近有语法错误。

[以学习为目的]

create trigger sss  on pod_det
for insert
as 
insert into temp02(pod_ponbr,itm_itmnbr,rqu_num)
select a.pod_ponbr,b.itm_itmnbr,
b.mlot*((a.num/b.mlot)+1) from inserted a left outer join itm_det b on a.pod_itmnbr=b.itm_itmnbr
WHERE inserted.pod_itmnbr='aaa'

[以学习为目的]

主要是你插入语句写错了

create trigger sss  on pod_det
for insert
as
if inserted.pod_itmnbr='aaa' 
begin 
      insert into temp02(pod_ponbr,itm_itmnbr,rqu_num)
                      select a.pod_ponbr,b.itm_itmnbr,b.mlot*((a.num/b.mlot)+1)
                                    from inserted a left outer join itm_det b on a.pod_itmnbr=b.itm_itmnbr
end

[中国风]

create trigger sss  on pod_det
for insert
as
if EXISTS(SELECT 1 FROM inserted WHERE pod_itmnbr='aaa' )
begin 
   insert into temp02(pod_ponbr,itm_itmnbr,rqu_num)
   SELECT   a.pod_ponbr
           ,b.itm_itmnbr
           ,b.mlot * ( ( a.num / b.mlot ) + 1 )
   FROM     inserted a
            LEFT OUTER JOIN itm_det b ON a.pod_itmnbr = b.itm_itmnbr
;
end