Kreuzabfrage MySQL

[King^Lully]

  
SELECT  
 'X' as Segment,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 1) AND  
  (Segment = 'X')  
 ) AS Kl_1,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 2) AND  
  (Segment = 'X')  
 ) AS Kl_2,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 3) AND  
  (Segment = 'X')  
 ) AS Kl_3,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 4) AND  
  (Segment = 'X')  
 ) AS Kl_4,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 5) AND  
  (Segment = 'X')  
 ) AS Kl_5,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 6) AND  
  (Segment = 'X')  
 ) AS Kl_6,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 7) AND  
  (Segment = 'X')  
 ) AS Kl_7,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 8) AND  
  (Segment = 'X')  
 ) AS Kl_8,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 9) AND  
  (Segment = 'X')  
 ) AS Kl_9,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 10) AND  
  (Segment = 'X')  
 ) AS Kl_10,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 11) AND  
  (Segment = 'X')  
 ) AS Kl_11,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 12) AND  
  (Segment = 'X')  
 ) AS Kl_12,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 13) AND  
  (Segment = 'X')  
 ) AS Kl_13,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 14) AND  
  (Segment = 'X')  
 ) AS Kl_14,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 15) AND  
  (Segment = 'X')  
 ) AS Kl_15,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 16) AND  
  (Segment = 'X')  
 ) AS Kl_16,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 17) AND  
  (Segment = 'X')  
 ) AS Kl_17,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 18) AND  
  (Segment = 'X')  
 ) AS Kl_18,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 19) AND  
  (Segment = 'X')  
 ) AS Kl_19,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 20) AND  
  (Segment = 'X')  
 ) AS Kl_20,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 21) AND  
  (Segment = 'X')  
 ) AS Kl_21,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 22) AND  
  (Segment = 'X')  
 ) AS Kl_22,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 23) AND  
  (Segment = 'X')  
 ) AS Kl_23,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 24) AND  
  (Segment = 'X')  
 ) AS Kl_24,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 25) AND  
  (Segment = 'X')  
 ) AS Kl_25,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 26) AND  
  (Segment = 'X')  
 ) AS Kl_26,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 26) AND  
  (Segment = 'X')  
 ) AS Kl_27  
UNION SELECT  
 'Y' as Segment,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 1) AND  
  (Segment = 'Y')  
 ) AS Kl_1,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 2) AND  
  (Segment = 'Y')  
 ) AS Kl_2,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 3) AND  
  (Segment = 'Y')  
 ) AS Kl_3,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 4) AND  
  (Segment = 'Y')  
 ) AS Kl_4,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 5) AND  
  (Segment = 'Y')  
 ) AS Kl_5,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 6) AND  
  (Segment = 'Y')  
 ) AS Kl_6,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 7) AND  
  (Segment = 'Y')  
 ) AS Kl_7,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 8) AND  
  (Segment = 'Y')  
 ) AS Kl_8,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 9) AND  
  (Segment = 'Y')  
 ) AS Kl_9,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 10) AND  
  (Segment = 'Y')  
 ) AS Kl_10,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 11) AND  
  (Segment = 'Y')  
 ) AS Kl_11,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 12) AND  
  (Segment = 'Y')  
 ) AS Kl_12,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 13) AND  
  (Segment = 'Y')  
 ) AS Kl_13,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 14) AND  
  (Segment = 'Y')  
 ) AS Kl_14,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 15) AND  
  (Segment = 'Y')  
 ) AS Kl_15,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 16) AND  
  (Segment = 'Y')  
 ) AS Kl_16,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 17) AND  
  (Segment = 'Y')  
 ) AS Kl_17,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 18) AND  
  (Segment = 'Y')  
 ) AS Kl_18,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 19) AND  
  (Segment = 'Y')  
 ) AS Kl_19,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 20) AND  
  (Segment = 'Y')  
 ) AS Kl_20,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 21) AND  
  (Segment = 'Y')  
 ) AS Kl_21,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 22) AND  
  (Segment = 'Y')  
 ) AS Kl_22,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 23) AND  
  (Segment = 'Y')  
 ) AS Kl_23,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 24) AND  
  (Segment = 'Y')  
 ) AS Kl_24,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 25) AND  
  (Segment = 'Y')  
 ) AS Kl_25,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 26) AND  
  (Segment = 'Y')  
 ) AS Kl_26,  
 (  
 SELECT  
  Sum(Flaeche)  
 WHERE  
  (Klasse = 26) AND  
  (Segment = 'Y')  
 ) AS Kl_27  

Sexy, oder?