hi

fldid           date                     value1                     value2                                 item

1         12/12/2003                 10                             20                                     id1
2         12/13/2003                 30                             40                                     id3


The obove are table screma with values

now write a query to display in this manner


date                          value1            value2    
12/12/2003                 10                 20 


query --- select  date,value1,Value2  where date=12/12/2003


date                                 value1             value2   
12/13/2003                         30                 40 

query --- select  date,value1,Value2  where date=12/13/2003


now if u write 2 sqls by using union ..etc  then u will get two rows


but i want u to write only one sql so that u display in one row  in this manner


value1                         value2                |        value1         value2      

10                                 20                   |          30             40

Regards


N.Mallikarjuna Reddy