Hello

yeah, it's possible using sql query. but u have to write a subquery to get the 
actual output.

regards

jabed



----- Original Message ----
From: Arif Uddin <[EMAIL PROTECTED]>
To: Bd <[email protected]>; Linux Warrior <[EMAIL PROTECTED]>; FedoraBD 
Forum <[EMAIL PROTECTED]>
Sent: Saturday, July 26, 2008 7:43:04 PM
Subject: [bdlug] help about a sql for mysql database


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