INSERT INTO [Table to copy To]
  SELECT [Columns to Copy]
  FROM [Table to copy From]
  WHERE [Optional Condition];