Project#1

select a.giftkey,a.giftid,a.gifthonor, b.gifthnrkey,b.giftid,b.gifthonor

from gifts a left outer join dbo.gifts b

on a.giftid = b.giftid

where a.gifthonor is not null

It simply repeats data. I am trying to list a.giftkey once then...

I have a similar issue except I want to display an ID and and HonorDesigination as follows

ID HonorDesignation

111 M

111 ...