将数据从表插入

INSERT INTO CommentTable (Date, Site, Comments, Total)SELECt '2010-04-01 00:00:00.000', Site, 0, 0FROM SiteTableWHERe Site NOT IN    (SELECt DISTINCT Site FROM CommmentTable     WHERe [Date] = DATEADD(mm, DATEDIFF(mm, 0, GetDate()) -1,0))