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 6:45 am

    #1615742

    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

    lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID

    This will fail unless you have lyrCompletedRecips in your FROM list.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden