>Hi Naomi,
>
>In order to get what Denis wants you need another join and also you should use different and not less than (As you very well know, I might be wrong yet again)
>
>

>      Select * from c_test A1 JOIN c_test B1 on A1.Rec <> B1.Rec JOIN c_test C1 on A1.Rec <> C1.Rec AND B1.Rec <> C1.Rec ORDER BY A1.Rec, B1.Rec, C1.Rec
>

>
>But is not very scalable.

I wanted to get
1-2
1-3
1-4
2-3
3-4

etc. - all variations of 2 numbers.