Concatenate multi value into one record
<p>I joined two tables together and what I like to do is concatenate multi vaule in one records without duplicated value.</p>

<ol>
<li><p>Input Table<br/><br/>
Table name: TAXLOT_ZONE<br/>
TID   ZONE<br/>
1     A<br/>
1     A<br/>
1     B<br/>
1     C<br/>
2     D<br/>
2     D <br/>
2     E<br/>
3     A<br/>
3     B<br/>
4     C<br/>
5     D<br/></p></li>
<li><p>Desirable output table looks like;<br/><br/>
table name: Taxlot_zone_out<br/>
TID  ZONE<br/>
1    A, B, C<br/>
2    D, E<br/>
3    A, B<br/>
4    C<br/>
5    D<br/></p></li>
</ol>
