Hi Guys,

Unfortunately neither of those scripts worked as there are multiple identical accountno and lastdate fields. Ideally Id need to filter on the History tables Recid field.

I've dummied up some data for you to look at

CREATE TABLE #CONTACT

(

ACCOUNTNOVARCHAR(5),

COMPANYVARCHAR(50),

CONTACTVARCHAR(50),

RECIDVARCHAR(5)

)

CREATE TABLE #HISTORY

(

ACCOUNTNOVARCHAR(5),

LASTUSERVARCHAR(8),

LASTDATEDATE,

RECIDVARCHAR(5)

)

INSERT INTO #CONTACT (ACCOUNTNO, COMPANY, CONTACT, RECID)

SELECT 'C1', 'ACME', 'WILEY COYOTE', 'CR1' UNION ALL

SELECT 'C2', 'Beta Ltd', 'Joe Soap', 'CR2'

INSERT INTO #HISTORY (ACCOUNTNO, LASTUSER, LASTDATE, RECID)

SELECT 'C1', 'JOE', '20120101', 'HR1' UNION ALL

SELECT 'C1', 'BOB', '20120101', 'HR2' UNION ALL

SELECT 'C1', 'JOE', '20120201', 'HR3' UNION ALL

SELECT 'C2', 'JOE', '20120202', 'HR4' UNION ALL

SELECT 'C2', 'BOB', '20120202', 'HR5'

How would I get a History select script to return HR1 and HR4?

Thanks