I don't really get what you mean. But you can try to union it.
SELECT SCHEME_ID, SCHEME_YEAR
FROM SCHEMETRN1
UNION
SELECT SCHEME_ID, SCHEME_YEAR
FROM SCHEMETRN2
OR
SELECT *
FROM SCHEMETRN1
INNER JOIN SCHEMETRN2 ON SCHEMETRN2.SCHEME_ID = SCHEMETRN1.SCHEME_ID
AND SCHEMETRN2.SCHEME_YEAR= SCHEMETRN1.SCHEME_YEAR