Duplicate rows (need new table)

[#1]

Hi, i have a table like this:

id	field1	field2
a1	dat1	f1
a1	dat11	f1
a1	dat111	f1
a2	dat2	ta2
a2	dat2	ta22
a3	dat3	f3
a4	dat4	f4
a4	dat44	f4

i need join wiht itself (a new table) but only takes a unique id, like this:

id

a1

a2

a3

a4

thanks!!!

[#2]

Load Distinct

     id,

     field1,

     field2

Resident Table;

but with the data U show all rows will be in the new table.

So if u need atable as shown in the example the story goes like this:

Load Distinct

     id

Resident Table;

The u will have separate table with only unik values in filed id.

Brg

//KArathorn

[CELAMBARASAN]

What are you trying to achieve by that?

If you explain explain little more clear it is easier to give you a better solution.