SQL - Concatanation of all values in a foreign table to use in the primary table
I have one table that has sales records and another table that has additional details on each record. What I need to do is build a query that will query the first table and, for each record, list additional details in a virtual column, like this:
"Additional detail #1 for record 1: some additional detail; Additional detail #2 for record 1: more additional details;..." Basically, this column is a concatenation of all additional field record values.

There is no limit on how many additional details (records in the additional details table) one record from the primary table can have.

Do you have any suggestions on how to do this?
SQL - Concatanation of all values in a foreign table to use in the primary table
===

I have one table that has sales records and another table that has additional details on each record. What I need to do is build a query that will query the first table and, for each record, list additional details in a virtual column, like this:
"Additional detail #1 for record 1: some additional detail; Additional detail #2 for record 1: more additional details;..." Basically, this column is a concatenation of all additional field record values.

There is no limit on how many additional details (records in the additional details table) one record from the primary table can have.

Do you have any suggestions on how to do this?