Yes

Hi

I've worked out the problem.

from members_.memberID_ with (nolock)

shouldn't have memberID_ in the SQL

Thanks

Many thanks - this works perfectly

Yes I've corrected that

Sorry, afraid not

thanks

The naming convention was decided by someone else

select

List_,

Description,

count(month(TimeClicked)) as MonthTimeClicked

from clicktracking_ with (nolock)

inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_

inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID

group by

List_,

Description