2013/6/19 Jashaswee <sweet.rink...@gmail.com> > The column value looks like this: > > Quantity > 2000 > -1000 > > both the quantity values are of a same product.but i want these in a > single > line. > so what i want is a result set that looks like: > In quantity Out quantity > ----------- ------------ > 2000 -1000 >
How do we decide wether 2000 or -1000 refers to the “In quantity”? Can you show a complete table's structure, please? -- Victor Y. Yegorov
