Vinay Theethira (6/24/2010)

---

Here is my SQL Query, This query should not fetch duplicate contactID(i.e Same ContactID).but when i execute the query i get duplicated ContactID. Could anyone tell me what is wrong with my Query,

Here is my query

select ContactTracking.Contact_ID

FROM

ContactTracking ContactTracking

LEFT OUTER JOIN Issues Issues ON ContactTracking.Issue_ID = Issues.Issue_ID

LEFT OUTER JOIN HRA hra ON hra.HcnID = ContactTracking.HcnID

INNER JOIN HPS_COMMON.dbo.wrk_user wrk_User ON ContactTracking.UserID = wrk_User.id_User

INNER JOIN HPS_COMMON.dbo.def_Usertype def_Usertype ON wrk_User.id_UserType = def_Usertype.id_UserType

WHERE

ContactTracking.contact_date>'10-jan-2009'

AND ContactTracking.Call_end_time is not null

AND Contact_ID in ('122734','122738')

And here is the ContactId result i get,

122734

122734

122738

122738

Expected Result is,

122734

122738

So i thought Group By will solve the iss