SELECT CT.Contact_ID
FROM ContactTracking CT
WHERE CT.contact_date > '20090110'
AND CT.Call_end_time IS NOT NULL
AND Contact_ID IN ('122734', '122738')
AND EXISTS
(
SELECT *
FROM HPS_COMMON.dbo.wrk_user WU
JOIN HPS_COMMON.dbo.def_Usertype UT
ON UT.id_UserType = WU.id_UserType
WHERE WU.id_User = CT.UserID
);
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi