这么处理应该可以,方法有点笨.没想好有什么好办法
create table a1 (bb char(1) not null)
insert into a1 values('1')
insert into a1 values('2')
insert into a1 values('3')
select * from a1
union all
select a1.bb+b1.bb from a1,(select * from a1) b1 where a1.bb<> b1.bb
union all
select a1.bb+b1.bb+c1.bb from a1,(select * from a1) b1,(select * from a1) c1 where a1.bb<> b1.bb and b1.bb<>c1.bb and a1.bb<>c1.bb