transpose result of query from mysql

[danielbl]

I need of result below in different way

Thanks any help!

QUERY:

SELECT
t.`trafego_data`,
u.`uf_sigla`,
sum(t.`trafego_qtd`) as trafego_qtd
 
FROM
trafego t INNER JOIN uf_ddd u ON t.`uf_ddd_cod` = u.`uf_ddd_cod`
WHERE
t.`trafego_data` BETWEEN '20070801' AND '20070803' AND
t.`trafego_skill` = 'VENDAS SAC'
GROUP BY t.`trafego_data`,u.`uf_sigla`
ORDER BY t.`trafego_data`,u.`uf_sigla`, trafego_qtd

RETURN OF QUERY

trafego_data    uf_sigla    trafego_qtd
1/8/2007    AC    6
1/8/2007    AL    1
1/8/2007    BA    4
1/8/2007    CE    2
1/8/2007    DF    3
1/8/2007    ES    1
1/8/2007    GO    1506
1/8/2007    MA    2
1/8/2007    MG    29
1/8/2007    MT    788
1/8/2007    NI    404
1/8/2007    PA    11
1/8/2007    PE    9
1/8/2007    PI    1
1/8/2007    PR    3482
1/8/2007    RJ    21
1/8/2007    RN    1
1/8/2007    RO    30
1/8/2007    RS    3022
1/8/2007    SC    1864
1/8/2007    SP    34
1/8/2007    TO    295
2/8/2007    AC    4
2/8/2007    AL    1
2/8/2007    AM    1
2/8/2007    AP    1
2/8/2007    BA    5
2/8/2007    CE    3
2/8/2007    DF    6
2/8/2007    ES    2
2/8/2007    GO    1490
2/8/2007    MA    3
2/8/2007    MG    17
2/8/2007    MS    5
2/8/2007    MT    688
2/8/2007    NI    351
2/8/2007    PA    6
2/8/2007    PE    3
2/8/2007    PR    3241
2/8/2007    RJ    26
2/8/2007    RN    3
2/8/2007    RO    15
2/8/2007    RS    2672
2/8/2007    SC    1518
2/8/2007    SP    48
2/8/2007    TO    239
3/8/2007    AC    8
3/8/2007    AL    7
3/8/2007    AM    7
3/8/2007    AP    1
3/8/2007    BA    4
3/8/2007    CE    1
3/8/2007    DF    4
3/8/2007    ES    2
3/8/2007    GO    1107
3/8/2007    MA    7
3/8/2007    MG    20
3/8/2007    MS    6
3/8/2007    MT    694
3/8/2007    NI    284
3/8/2007    PA    7
3/8/2007    PB    1
3/8/2007    PE    3
3/8/2007    PI    1
3/8/2007    PR    2452
3/8/2007    RJ    13
3/8/2007    RO    31
3/8/2007    RS    2338
3/8/2007    SC    1226
3/8/2007    SP    38
3/8/2007    TO    208

I NEED THE RETURN LIKE THAT:

DIA        AC   DF   GO   ..., 
1/8/2007   6    3    1506
2/8/2007   4    6    1490
3/8/2007   8    4    1107

THANKS ANY HELP!

[pbmods]

Heya, Daniel. Welcome to TSDN!

MySQL really won't be able to give you exactly what you want there.

You have three options:

• You can run a separate query for each day and then parse the results in a separate script (e.g., PHP).
• You can use what you're currently getting and do all of the calculations in a separate script (e.g., PHP).
• You can create a stored procedure to create a table with one column for each distinct value of `uf_sigla`, and then run a query for each `uf_sigla` and populate each column of the table. If it absolutely has to be done in MySQL, then this is the way you'd have to do it *HOWEVER* note that this is probably the slowest way, performance-wise, to do it!