查询出交叉的结果

Question

我现有一表table，表中有3列  name  deptname checkType                           a      1        A1
                           b      1        A2
                           c      1        A3
                           a      1        A4
                           b      1        A5
                           c      1        A6我现在想查询出的结果为  a 1  A1 A4
                     b 1  A2 A5
                     c 1  A3 A6大家帮帮忙~  SQL语句该怎么写~？    

Answer 1

http://topic.csdn.net/u/20071127/20/92aaaa1d-3707-4c2d-a9bd-4f4cb17477fb.html