Multipart identifier cannot be bound error on update

• SQLTestUser

  Hall of Fame

  Points: 3997

  More actions

  April 22, 2011 at 12:34 pm

  #236214

  update permanentCM

  SET X.Validate =

  (Select Y.Comment

  where X.Id = Y.problemId) where exists (Select Y.Comment

  where X.Id = Y.Id)

  and i get an error as

  Msg 4104, Level 16, State 1, Line 2

  The multi-part identifier "Y.Id" could not be bound.

  Msg 4104, Level 16, State 1, Line 2

  The multi-part identifier "Y.ID" could not be bound.

  X.validate and Y.commnet both are nvarchar fields

  is there another way i can update the table.

• sixthzenz

  Right there with Babe

  Points: 740

  More actions

  April 22, 2011 at 1:33 pm

  #1315020

  i think you need a FROM clause in there because you're referencing two objects, X and Y