example.sql

SELECT
    s.SERVER_NAME as SERVER_NAME,
    s.FOO,
    s.BAR,
    s.TIMESTAMP as SERVER_TIME,
    n.SERVER_NAME as N_SERVER_NAME,
    n.TIMESTAMP as N_TIME,
    n.BAH,
    n.BAZ,
    EXTRACT(EPOCH from s.TIMESTAMP - n.TIMESTAMP) as DIFF
FROM
    TABLE1 s
FULL OUTER JOIN
    TABLE2 n ON
    s.SERVER_NAME = n.SERVER_NAME AND
    EXTRACT(EPOCH from s.TIMESTAMP - n.TIMESTAMP) <= 300 AND EXTRACT(EPOCH from s.TIMESTAMP - n.TIMESTAMP) >= 0
LIMIT 50;