|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
|
|||
|
|||
|
output format
my table is item which has four columns(it_id int,year date,define varchar,value varchar myisam),150000 rows
sample; it_id,year,define,value -----,----,------,----- 10,1998,asder,4578 10,2000,derse,56987 10,2001,dersen,7899 10,2002,versen,8899 10,2003,keren,7899 11,1999,sanal,56 11,2001,kanal,78 13,2001,buras,111 .... I can't change database design. I want to see view output year and value but values side by side for it_id. forexample(select it_id for 10,11 ,do could'nt date,always all date selected) year,val_10,val_11,... ----,------,------, 1998,4578,null 1999,null,56 2000,56987,null 2001,7899,78 2002,8899,null 2003,7899,null ..... What can I do,How can.? thanks for help. |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > output format |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|