Find missing entries across several tables by SQL call
SELECT *
FROM SysN sy
WHERE NOT EXISTS ( SELECT NULL
                   FROM summary su
                   WHERE (su.name, su.date, su.sys) = (sy.name, sy.date, 'SysN') )

Execute 7 separate queries or combine them via UNION ALL into one query.