原始表,两个字段,如下:
A zhangsan
A lisi
B wangwu
B merce
查询后显示为三个字段如下:
A zhangsan
A lisi
B wangwu
B merce
/*
create table test (f1 varchar(2) null,desc1 varchar(10) null)
insert into test (f1,desc1) values('A','zhangsan')
insert into test (f1,desc1) values('A','lisi')
insert into test (f1,desc1) values('B','wangwu')
insert into test (f1,desc1) values('B','merce')
*/
------解决方案--------------------
楼主给的例子还是两个字段...
------解决方案--------------------
- SQL code
select f1,null,desc1 from test2 where f1='A' union all select null,f1,desc1 from test2 where f1='B'