( Ex: SQL-Server Syntax) select a.fld1, a.fld2, a.fld3, sum( a.fld4) fld4 into MyDataBase.dbo.NewTable from MyDataBase.dbo.MySource a group by a.fld1, a.fld2, a.fld3 No where clause required... and the result of this set may be about 1,000 records (not large) Then we need to further derive data from that and issue select a.fld1, a.fld2, sum( a.fld3 ) fld3, sum( a.fld4 ) fld4 into MyDataBase.dbo.AnotherNewTable from MyDataBase.dbo.NewTable a group by a.fld1, a.fld2This version of the query fails... The back-end table should result with about 150 records from the original 1,000. HOWEVER, if we drop the table MyDataBase.dbo.AnotherNewTable after it was created here, then re-issue the exact same statement, we get the proper results.