SELECT A.*, B.Note FROM A LEFT JOIN ( SELECT fk, Note, ROW_NUMBER() OVER (PARTITION BY fk ORDER BY InsertDate DESC) AS rn FROM B ) B ON B.fk = A.pk AND B.rn = 1;