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
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