SELECT file1.name,address FROM file1, file2
   WHERE file1.name = file2.name
     AND rank = 'General';