I have this table:
And - I want to achieve this:
|723983||A5Q||Maria; Ken; Phil|
So, if more than 1 assignee is assigneed to the same task, in the same book -> merge them into ONE cell (;).
Is there a way to do it in Teradata SQL Assistent..?
you should be able to accomplish this with some group by statements, left outer joins and a couple of <> conditions
Based on Ulrich's response for http://forums.teradata.com/forum/database/parent-child-relationship-flattening
Please find below query: