-- Inner join between the 'RESPONSE' and 'MASTER' tables on field 'INT_NO' (interview number).
-- This join forms the base view required by the 'SPANDIAL' and 'SPANGRAM' queries
-- which model the corresponding 'sets' in Alpha 4.

SELECT RESPONSE.INT_NO, RESPONSE.ENG, RESPONSE.SPANISH, RESPONSE.CODE, RESPONSE.RECNO
FROM MASTER INNER JOIN RESPONSE ON MASTER.INT_NO = RESPONSE.INT_NO;