AnsweredAssumed Answered

Update sql Question

Question asked by ben.jones on Jun 29, 2012
Latest reply on Jun 29, 2012 by Dave
I'm trying to update a field that I've created in the investment object with the details of the original field that I originally created in the project object. Both use the same lookup. The sql is below, it's running but not updating anything, can anyone see anything wrong with it? Or is there a better way to write this?

update niku.odf_ca_inv
set o2_inv_type= 'full_o2'
where (select proj.id from niku.odf_ca_project proj where niku.odf_ca_inv.id=proj.id and proj.o2_proj_type='full_o2')=1

Outcomes