Update question

• Ben Thieson

  SSC Rookie

  Points: 39

  More actions

  March 13, 2007 at 3:23 pm

  #68088

  I'm trying to update a table with the following:

  UPDATE clean SET clean.branchid = branches.branchid FROM clean WHERE clean.ppi = branches.ppi

  I tried it with an INNER JOIN but that also gave me the following error:

  syntax error(missing operator) in query expression 'branches.branchid FROM clean'

   

  If you have any ideas, I will gladly hear them. I'm sure it's just a stupid little mistake I made.

  Thanks!

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  March 14, 2007 at 10:37 am

  #695018

  Try

  UPDATE clean SET branchid = branches.branchid

  FROM clean inner join branches on clean.ppi = branches.ppi

  Russel Loski, MCSE Business Intelligence, Data Platform