表A
QID p1 PE1 PN1 P2 PE2 PN2 P3 PE3 PN3 P4 PE4 PN4
1 1 1 1 2 2 2 3 3 3 4 4 4想要查询出来的结果是 P PE PN
1 1 1
2 2 2
3 3 3
4 4 4请各位高手帮下忙
QID p1 PE1 PN1 P2 PE2 PN2 P3 PE3 PN3 P4 PE4 PN4
1 1 1 1 2 2 2 3 3 3 4 4 4想要查询出来的结果是 P PE PN
1 1 1
2 2 2
3 3 3
4 4 4请各位高手帮下忙
select p1,pe1,pn1 from a where p1=1
union
select p2,pe2,pn2 from a where p1=2
union
select p3,pe3,pn3 from a where p1=3
union
select p4,pe4,pn4 from a where p1=4