DROP TABLE OfficeDuplicates; Create Table OfficeDuplicates AS SELECT * from FolderData AS Origin INNER JOIN FolderData AS Dup ON Dup.Project = Origin.Project where Origin.Project in ( select Project from FolderData group by Project HAVING count(*) > 1 ) AND Dup.Server != Origin.Server ORDER BY Origin.Server, Origin.Project;