Image

Imagedana wrote in Imagesqlserver



INSERT INTO Dana_MMMErrorSummary.ErrorNum
SELECT    ErrorNum
FROM                 Dana_MMMFriday FULL OUTER JOIN
                      Dana_MMMTuesday ON Dana_MMMFriday.ErrorNum = Dana_MMMTuesday.ErrorNum FULL OUTER JOIN
                      Dana_MMMWednesday ON Dana_MMMFriday.ErrorNum = Dana_MMMWednesday.ErrorNum FULL OUTER JOIN
                      Dana_MMMMonday ON Dana_MMMFriday.ErrorNum= Dana_MMMMonday.ErrorsNum FULL OUTER JOIN
                      Dana_MMMSaturday ON Dana_MMMFriday.ErrorNum= Dana_MMMSaturday.ErrorNum FULL OUTER JOIN
                      Dana_MMMThursday ON Dana_MMMFriday.ErrorNum = Dana_MMMThursday.ErrorNum FULL OUTER JOIN
                      Dana_MMMSunday ON Dana_MMMFriday.ErrorNum= Dana_MMMSunday.ErrorNum
GROUP BY ErrorNum