Hi all,
I want to know is there any way possible for me to select let's say 4 distinct columns + 1 not distinct column in one sql sentence?

I have following:
-UserRealName, UserEmail, UserCompany in tbl_UserMaster
-UserID, UserName in tbl_User
-UserID, DonatedFee, RecDate in tbl_Donate.

I want to get UserRealname, UserEmail, UserName, DonatedFee, RecDate.

Here is what I tried:

Code:
SELECT DISTINCT UM.UserName AS Name, UM.UserEmail AS UserEmail, UM.UserCompany AS UserCompany, 
ISNULL(U.UserName,'') AS UserName, ISNULL(D.DonatedFee,0) AS DonatedAmount, D.RecDate AS RecordDate
FROM tbl_UserMaster AS UM RIGHT JOIN tbl_User AS U ON 
U.UserName = UPPER(LEFT(UM.UserEmail,CHARINDEX('@',UM.UserEmail)-1)) LEFT JOIN tbl_Donate AS D 
ON D.UserID=U.UserID WHERE U.UserID NOT IN(SELECT DISTINCT UserID FROM tbl_Donate WHERE 
YEAR(RecDate) BETWEEN 2009 AND 2009 AND MONTH(RecDate) BETWEEN 5 AND 5 AND DAY(RecDate)  BETWEEN 8 AND 8) 
group by UM.UserName, UM.UserEmail, UM.UserCompany, U.UserName, D.DonatedFee, D.RecDate
It will retrieve a list of records but the records is not in distinct. It returns duplicate records.

Is there any way to retrieve all distinct records neglect the date column but want to include in result list?

Thanks your help.

P.S: I'm not that good enough in SQL too. The above sql and table structure of mine may be ugly but please forgive me