There is nothing wrong with your syntax. There's no "limits" to what you're trying to do. So check your syntax carefully and make sure you don't have a tiny typo somewhere, or breaking a rule, etc... Get yourself some data and then chop down your Update to just updating 2 columns. If that works, then add more columns one at a time.
Karen > I have tried working this out when by using a temp table and then once > confirmed all the data is there that is required, I want to now update the > permanent table. Everything works great until the update. Are there any > restrictions on updating from a temp table? These tables have a lot of > information. > > > > My syntax looks like this, except for I’m updating every column instead of > just two: > > > > Update clients set status = t2.status, casemanager = t2.casemanager + > > From clients t1, tclients t2 + > > Where t2.client# = t1.client# > > > > Thanks. > > >
