• 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

    );