计算全排列,有没有比较短小的好办法？

用cross join 感觉语句太长了，如果是n个数字就会长，有没有短小的？--建表---CREATE TABLE t1(c1 varchar(40) )
insert INTO t1(c1) values (1 )
insert INTO t1(c1) values (2)
insert INTO t1(c1) values (3 )---语句---
 select * from t1 a cross join t1 b cross join t1 c where a.c1!=b.c1 and a.c1!=c.c1 and b.c1!=c.c1 
--结果：
c1                                       c1                                       c1                                       
---------------------------------------- ---------------------------------------- ---------------------------------------- 
1                                        3                                        2
1                                        2                                        3
2                                        3                                        1
2                                        1                                        3
3                                        2                                        1
3                                        1                                        2
(6 row(s) affected)