Hello all, I've tried different kinds of joins, etc., to no avail on the following problem, and can't solve this without getting duplicate lines of data. Help would be greatly appreciated. I hope these columns line up, but effectively I'm trying to concatenate text fields grouped by their unique id, so that the id, full issue text, and full outcome text are represented by the unique id for the event. (It's not my database; can't imagine why it is setup like this).
Thanks,
gnixon
Table issue
id issue_text
0001 Customer unhappy
0001 with goods. Wanted
0001 red, got blue.
0002 Manager was rude.
Table outcome
id outcome_text
0001 Sent red, resolved.
0002 Manager will
0002 send apology.
Desired Result as Follows:
issue.issue_text outcome.outcome_text
0001 Customer unhappy with goods. Wanted red, got blue. Sent red, resolved.
0002 Manager was rude Manager will send apology.
Thanks,
gnixon
Table issue
id issue_text
0001 Customer unhappy
0001 with goods. Wanted
0001 red, got blue.
0002 Manager was rude.
Table outcome
id outcome_text
0001 Sent red, resolved.
0002 Manager will
0002 send apology.
Desired Result as Follows:
issue.issue_text outcome.outcome_text
0001 Customer unhappy with goods. Wanted red, got blue. Sent red, resolved.
0002 Manager was rude Manager will send apology.