Simplify a table

[stascher]

Hi.  I should lose points for asking this, it's such a simple question, but I keep getting a load error.

I have a table Table1 like:

column_1	column_2
A	AA
A	BB
A	CC
B	DD
B	EE
B	FF

I want to create the following Table2:

column_a	column_b
A	AA,BB,CC
B	DD,EE,FF

Table2:

load distinct column_1 as column_a,

concat(column_2,',') as column_b

resident Table1;

The above doesn't work. What should I be using?

[stascher]

Nevermind,. I forgot the Group BY clause.