Hi...

Try this:

Update PatientTable

Set Notes = 'NOTES' + ' This is a new TEXT Message'

Where PatientId =

(Select PatientID From PatientVisitTable

Where TicketNumber = 9)