I have two tables in a master-detail relationship. For example:

Customers
===============
Custid
Field1
Field2
Field3
Custnotes

Sales
===============
Saleid
Custid
FieldA

What I want to do is take all of the Sales for each customer and dump the
contents of ALL of the FieldA values into the single Custnotes field. So,
if a customer has 4 Sales records, then that customer's Custnotes field
would have 4 FieldA values contatenated together.

Is there a way to do this in SQL?

-Joe