Post reply

How to Update Linked tables

  • May 23, 2004 at 10:26 pm

    #107883

    How to Update Linked tables.

    I Want to update alarmconfig table where Linked table.

    My problem is following query is working for ACCESS but not with SQL

    Update AlarmConfig,Alarmdef

    Set AlarmConfig.VectoringGroupID = 1 Where AlarmDef.PointId = 2 And AlarmDef.AlarmDefID = AlarmConfig.AlarmDefID

    This gives the error message

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near ','.




    My Blog: http://dineshasanka.spaces.live.com/

  • May 23, 2004 at 10:45 pm

    #507408

    UPDATE a SET VectoringGroupID = 1

    from AlarmConfig A INNER JOIN AlarmDef B

    ON A.AlarmDefID = B.AlarmDefID

    Where B.PointId = 2




    My Blog: http://dineshasanka.spaces.live.com/

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

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