Query for joining columns of single table [message #261396] |
Wed, 22 August 2007 08:53  |
abhitabh.jamankar
Messages: 4 Registered: August 2007 Location: India
|
Junior Member |
|
|
Hi all,
i have one table (sender, receiver , error)
error having (SUCCESS and ERROR) values
like
sender receiver error
--------- ----------- --------
PO TOM SUCCESS
PO TOM SUCCESS
DICK JOY ERROR
DICK JOY ERROR
DICK JOY SUCCESS
PO TOM ERROR
DICK JOY ERROR
DICK JOY ERROR
PO TOM SUCCESS
DICK JOY SUCCESS
now i want do display SUCCESS and ERROR values in different columns
like
sender receiver OK ERR
--------- ----------- ----- ------
PO TOM 3 1
DICK JOY 2 4
Thanks
|
|
|
|
|
|
|