Home Forums SQL Server 2008 SQL Server 2008 - General The multi-part identifier "Members.MemberID_" could not be bound. RE: The multi-part identifier "Members.MemberID_" could not be bound.

  • May 16, 2013 at 5:47 am

    #1615717

    philip.davy (5/16/2013)

    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

    Query you posted refers to the table with name "Members_"

    Error shows "Members" - no underscore at the end.

    Actually, you have a very strange naming convention...

    Why do you add underscore at the end of some table and its columns names?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]