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.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges