Concatenating different columns and rows in Teradata
<p>I have two columns with data like this-</p>

<pre><code>aaaaa   bbbbb

ccccc   ddddd

ddddd   eeeee
</code></pre>

<p>and I want to display my results as:</p>

<pre><code>aaaaa-bbbbb;ccccc-ddddd;ddddd-eeeee
</code></pre>

<p>and so on. Concatenated into one long string.
How should I go about doing this in Teradata?</p>