Home Forums SQL Server 2005 SQL Server 2005 General Discussion The multi-part identifier could not be bound RE: The multi-part identifier could not be bound

  • August 27, 2009 at 2:57 pm

    #1045905

    Pakki (8/27/2009)

    Not sure if I am overlooking this, the last 'ON' cluase is,

    ON c.ID = t1.ClaimID

    Dont you think it should be tli1 instead of t1 in t1.ClaimID?

    Ohh sorry, you cant use that t1.claimID directrly in ON clause. Give an alias for that and then use it in here!

    Cant use tli1.ClaimID as ClaimID belongs to Transaction (t1). t1 is the alias for the table :-). I also tried using the full table name but that gave the same error.