Thanks for the response.

The update does not have a sub query in, it is a straight forward statement :

updatetable1

set fld1= ltrim(rtrim(table3.title)+' '+ rtrim(table3.forenames)+' ' + rtrim(table3.surname))

from table1...