DROP TABLE ANSW;
CREATE TABLE ANSW
AS
	SELECT
		AGENT_ID,
		INFORMATION_ID
	FROM
		INFO_ACCESS
;
SELECT
	GLEANED_DATE
FROM
	INFORMATION
WHERE
	AGENT_ID IN
	(
	SELECT 
		AGENT_ID
	FROM
		ANSW
	)
;
SELECT
	ANSW.AGENT_ID,
	ANSW.INFORMATION_ID,
	INFORMATION.GLEANED_DATE
FROM
	ANSW
INNER JOIN
	INFORMATION
USING
	(AGENT_ID)
;