Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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
What are you trying to achieve by that?
If you explain explain little more clear it is easier to give you a better solution.