combining records via SQL

[flynn]

Given this database structure:

 

table InvItem

table InvItemDetails

 

where the InvItem has many InvItemDetails records linked by a the ItemID, is there an SQL statement that will combine all of the InvItemDetails.Desc fields into a single string and return that string to me?

 

tia,

flynn