SELECT DISTINCT d.banner_id_1 as ID_num
from dbo.hourdata AS d LEFT JOIN (select id_2, Last_name from dbo.hourdata) AS A
On a.id_2 = d.id_1