SELECT file1.*, file2.array, file2.value FROM file1, file2 WHERE file1.chr = file2.chr and file1.coord = file2.coord;