2013/6/19 Jashaswee <sweet.rinky72@xxxxxxxxx>
How do we decide wether 2000 or -1000 refers to the “In quantity”?
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
Victor Y. Yegorov
