Create Trigger XXTri_Plan_AddShortNote on IcMo
After Insert
AS
Begin
Set Nocount ON
Update a Set a.[FHeadSelfJ0172]=(select FFullName from t_AuxItem and SEOrderEntry where t_AuxItem.FItemID=SEOrderEntry.FAuxPropID)
from IcMo a inner join SeOrderEntry b on a.FOrderInterId=b.FInterId and a.FSourceEntryId=b.FEntryId and a.FItemId=b.FItemId
End
麻烦各位大哥大姐看下红字部分是否正确
谢谢

select FFullName from t_AuxItem and SEOrderEntry
两个表的话不用and