update o_file

• denimblue

  Mr or Mrs. 500

  Points: 564

  More actions

  May 21, 2003 at 3:29 pm

  #80237

  MSSql 7

  I'm trying to update a table.

  update o_file f

  set groupid = 213

  where columnx 215

  and exists

  (select * from stutable1 a

  where f.fileid = a.o_objid)

  I get

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

  Line 1: Incorrect syntax near 'f'.

• tkbr0wn

  Ten Centuries

  Points: 1092

  More actions

  May 21, 2003 at 3:33 pm

  #458056

  Try this

  update f

  set f.groupid = 213

  from o_file as f

  where f.columnx = 215

  and exists

  (select * from stutable1 a

  where f.fileid = a.o_objid)