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?