Post reply

Error - 'The multi-part identifier A.Months could not be bound"

  • October 27, 2018 at 10:27 am

    #416394

    Hi

     In below query it is showing 'The multi-part identifier A.Months could not be bound" . I want to get months from another table where A.Location = [Test].Place

    Update [Test] set Active = 'Y' where Date > DATEADD(m,A.Months from [Test1] as A
    where A.Location = [Test].Place ,[RDate])

    Thanks

  • October 27, 2018 at 3:06 pm

    #2011457

    You'll need to join to the table [Test1]. You can't just dump a partial select inside a function where a column or value is required and expect it to work.

    UPDATE  Test ...
    FROM Test INNER JOIN TEST1 ON ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply