Mother daughter

[Anonymous]

Hi all,

The following table i have made:

Mother	Daughter
1	2
1	3
1	4
1	5

My result must be (mother en daughter must be the same in the same table)

Mother	Daugther
1	2
1	3
1	4
1	5
1	1

But how?

Best regards,

Arjan

[#2 · Accepted solution]

Would it help:

[prime table]:

LOAD Mother,

          Daugter

Resident [some table];

concatenate (prime table)

LOAD Distinct Mother,

          Mother as Daughter

Resident [prime table]

[Anonymous]

Thanks!!!

Regards,

Arjan