Update statement help please!

• Merlin Turner-464828

  Newbie

  Points: 8

  More actions

  July 15, 2007 at 8:52 pm

  #372780

  Hi guys!

  I have written this SQL statement, which works for Access, but I can't work out the equivalent for SQLServer.

  UPDATE tblMsgImp INNER JOIN tblMsgImp AS tblMsgImp_1 ON tblMsgImp.MID = tblMsgImp_1.MID

  SET tblMsgImp.MImp = [tblMsgImp_1].[MImp], tblMsgImp.MNote = [tblMsgImp_1].[MNote], tblMsgImp.MDate = [tblMsgImp_1].[MDate]

  WHERE (((tblMsgImp.BID)=1300102) AND ((tblMsgImp_1.BID)=1300101))

  Thanks

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  July 15, 2007 at 9:16 pm

  #719552

  You need to move the joins down...

  UPDATE tblMsgIMP

  SET ... (that whole string)

  FROM tblMsgImp INNER JOIN tblMsgImp AS tblMsgImp_1 ON tblMsgImp.MID = tblMsgImp_1.MID

  WHERE ... (where clause)

  That should work.

• Merlin Turner-464828

  Newbie

  Points: 8

  More actions

  July 15, 2007 at 9:29 pm

  #719554

  Many Thanks!