제가 사용한 쿼리 입니다.
 
3개의 테이블에서 쿼리는 하는데요


select group_name,example_ctrl_code,examiner_point

,(select  max(example_point)  from pqm_example_sheet es where sheet_gubun=23 and gubun='운영일반' and es.code=ur.example_ctrl_code

) as example_point

,(select  ismust   from pqm_question_sheet qs where sheet_gubun=23 and gubun='운영일반' and qs.code=ur.example_ctrl_code

) as ismust

 from pqm_user_result ur where gubun='운영일반' and sheet_gubun=23 group by group_name,examiner_point,example_ctrl_code order by group_name,example_ctrl_code


아래 처럼 결과가 나옵니다.


group_name    example_ctrl_code    examiner_point     example_point    ismust

  A                   1                                     2                    1                     Y
  A                   2                                     1                    2                     N
  B                   1                                     2                    3                     Y
  B                   2                                     1                    4                     N
  B                   4                                     1                    5                     Y
  C                   1                                     3                    6                     Y


이결과를  아래 처럼 할수는 없을 가요? 

(여기1)        group_name----------->
------------------------------------------------------------------------------------

1                 A                             B                                      C 

2                 examiner_point          examiner_point                  examiner_point

4                 examiner_point          examiner_point                  examiner_point


즉 group_name은 (중복되는것은 1개만 표시하고) X 축으로 보내구요 

Y 축으로는 example_ctrl_code    을 기준으로 표시 하구요 

그 사이에는 examiner_point    을 표시 하고 싶은데요 몇일을 고민해도 않됩니다.

보시는것처럼 example_ctrl_code 도 group_name 별로 중복 되는게 발생 합니다.

이것도 중복은 1개만 표시해서요....

도와 주세요~