I have 2 tables
1. tblENQUIRY and
The history contains the PK ENQUIRY_ID from the tblENQUIRY
What I need to do is create a new table with the 2 columns
ENQUIRY_ID and ENQ_FU_COMMENT
for each ENQUIRY_ID concatenate all of the individual lines in just one line.
like this ...
I really appreciate help on this.
My solution does not work correctly.