>id name year no >1 khubaib 2006 9 >1 khubaib 2007 10 > >now i want >id name no no >1 khubaib 9 10If you have only 2 records, you may use a self-join to create a select statement with what you want, e.g.
select FirstT.ID, FirstT.Name, FirstT.No as No1, SecondT.No as No2 ; from myTable FirstT inner join myTable SecondT ; on FirstT.ID = SecondT.ID and FirstT.Year <> SecondT.Year ; into cursor curOutput