SQL: Updating contents of a field by merging 2 fields together

SQL: Updating contents of a field by merging 2 fields together

I wondered if anyone could help me with something I am having some issues
with.
TB_SAMPLES contains a field called Notes. This field needs to be updated
with the contents of my reference table, SUNCORE_NOTES_UPDATE. I need to
add this new data as a prefix to any existing notes.
I have been able to select the values as I would like them to be displayed
but I am not able to undertake the update. My 'select' code is below:
select traxx_supportb.[jlr_sql].[suncore_notes_update].notes + ' ' +
tb_samples_nw.notes as fullnotes
from tb_samples_nw, traxx_supportb.[jlr_sql].[suncore_notes_update]
where tb_samples_nw.id = traxx_supportb.[jlr_sql].[suncore_notes_update].id
Can anyone help me with the SQL required to add the contents to
TB_SAMPLES.NOTES from SUNCORE_NOTES_UPDATE.NOTES as a prefix?
Thanks very much all! J