> > And why are you using "limit 1 offset 0"?
>
> becuase the subquery results in mutiple rowss.
> I want the first row to update title1,fname1,mname1,lname1,degs1
>
> and use the second row by using "limit 1 offset 1" to
> update title2,fname2,mname2,lname2,degs2 etc
>
> do u still want me to try the query u gave?
> (actually i did try and its giving some trivial error)
>
No. Looks like a misunderstanding.
Do I get it right this time assuming you want to
set up multiple update commands which update
only one row at a time?
Regards, Christoph