INSERT INTO [Dict_ReportItem] ( [RptItemName], [Seq], [FID], [IsAddSummary]) SELECT FeeItemName AS RptItemName,Seq=1,A.ID AS FID,IsAddSummary=1 FROM vi_FeeItem A LEFT JOIN Dict_ReportItem B ON A.ID=B.FID WHERE B.ID IS NULL AND A.ItemClass='普通' AND A.IsHide=0 SELECT * FROM vi_HisFeeItem WHERE ClassName LIKE '%迪安%' SELECT FeeItemName AS RptItemName,Seq=1,A.ID AS FID,IsAddSummary=1 FROM vi_FeeItem A LEFT JOIN Dict_ReportItem B ON A.ID=B.FID LEFT JOIN vi_HisFeeItem C ON WHERE B.ID IS NULL AND A.ItemClass='普通' AND A.IsHide=0 SELECT * FROM Enrollment_FeeItem WHERE EID=80668 UPDATE [Enrollment_FeeItem] SET ItemClass='普通' where [ID] = 1043064