Hello,
I believe it is possible, 
please study cross-tab 
you can also find some related code here 
http://dev.mysql.com/tech-resources/articles/wizard/print_version.html

Regards,

Md. Iqbal Hossain

http://www.SabaSafa.com

Do you need a coder?

--- On Sat, 7/26/08, Arif Uddin <[EMAIL PROTECTED]> wrote:
From: Arif Uddin <[EMAIL PROTECTED]>
Subject: [bdlug] help about a sql for mysql database
To: "Bd" <[email protected]>, "Linux Warrior" <[EMAIL PROTECTED]>, 
"FedoraBD Forum" <[EMAIL PROTECTED]>
Date: Saturday, July 26, 2008, 7:43 PM










    
            Hi experts



see the attached file and please help about that sql.

it's also follows



data on database on flowing format

============ ========= ========= ====

Day    Qnty  Qnty1

====    ====  =====

Sat    10    2

sum    2     1

mon    3     3

tues    5     4

wed    5     5

thus    7     6

Fri     1     7



I want to show it like following



Sat sun    mon tues wed thus fri

=== === === ===  === ==== ===

10  2   3   5    5   7    1

2   1   3   4    5   6    7



is it possible using sql command



Md. Arif Uddin 

Cell: +88 017 15 865458 

Email: [EMAIL PROTECTED] com 

http://arif. websitefree. org



----------



data on database on flowing format

============ ========= ========= ====



Day     Qnty  Qnty1

====    ====  =====

Sat     10    2

sum     2     1

mon     3     3

tues    5     4

wed     5     5

thus    7     6

Fri     1     7



I want to show it like following



Sat sun mon tues wed thus fri

=== === === ===  === ==== ===

10  2   3   5    5   7    1

2   1   3   4    5   6    7





is it possible using sql command





[Non-text portions of this message have been removed]




      

    
    
        
         
        
        








        


        
        


      

[Non-text portions of this message have been removed]

Reply via email to