Try SELECT * FROM PERSONS A INNER JOIN BANK B ON B.STUDENT_ID = A.STUDENT_ID AND B.CLASS_NO = A.CLASS_NO