select u.[Email Address] from UsableUsers u
left join HasOpened h
on u.[Email Address] = h.[Email Address]
WHERE h.[Email Address] is null