pivot - mysql pivoting - how can I fetch data from the same table into different columns? -

i have query looks this

select ps_target_ecpm, ps_actual_ecpm publisher_stats join domain on domain.dmn_id = ps_dmn_id left join langue on langue.lng_id = domain.default_lng_id month(ps_month) = 05  

the result set need should include fields this:

    may_target_ecmp, may_actual_ecpm, april_target_ecpm, april_actual_ecpm, march_target_ecpm, march_actual_ecpm.   april month(ps_month) = 04 , march month(ps_month) = 03 respectively. 

i tried union, subqueries , on - still no success. experiments lead me far, not needed

select a.ps_dmn_id, a.ps_actual_ecpm mayecmp, b.ps_actual_ecpm aprilecpm (     select *     publisher_stats     join domain on domain.dmn_id = ps_dmn_id     left join langue on langue.lng_id = domain.default_lng_id     month(ps_month) = 05  ) a, (     select *     publisher_stats     join domain on domain.dmn_id = ps_dmn_id     left join langue on langue.lng_id = domain.default_lng_id     month(ps_month) = 04 ) b  group ps_dmn_id 

what right query accomplish this?

you can try this

select ( case when ps_month = '04' ps_target_ecpm               else 0          end ) april_target_ecmp        ,( case when ps_month = '04' ps_actual_ecpm                else 0           end ) april_actual_ecpm        ,( case when ps_month = '03' ps_target_ecpm                else 0           end ) march_target_ecmp        ,( case when ps_month = '03' ps_actual_ecpm                else 0           end ) march_actual_ecpm     publisher_stats     join domain         on domain.dmn_id = ps_dmn_id     left join langue         on langue.lng_id = domain.default_lng_id