SELECT t1.user FROM t1 INNER JOIN t2 ON t2.User = t1.User WHERE t2.hDate <> DATE_FORMAT(NOW(), '%Y-%m-%d')