-- A query to reproduce the 'SPANGRAM' set (joined table view) which
-- is referenced by both the 'SPANDIAL' and 'VERIFY' applications in the Alpha 4
-- version of the Spanish dialect database.
-- Opens the RESPONSE table with constraint that Spanish terms must be grammatical items
-- as determined by inclusion in the 'GRAMMAR' table.

SELECT DISTINCT RESPONSE.INT_NO, RESPONSE.ENG, RESPONSE.SPANISH, RESPONSE.CODE, RESPONSE.RECNO
FROM RESPONSE INNER JOIN GRAMMAR ON RESPONSE.SPANISH = GRAMMAR.SPAN;