Home Forums SQL Server 7,2000 T-SQL update o_file RE: update o_file

  • 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)