How Can I get the OR Ranges and the Quantity In A Stub

See more:

VB

SQL

.NET

.NET4

i hope this time you can understand me
------------------------------------------------------------------------

MY SQL

   SELECT TOP 2 AFStubID ,ORNoFrom,ORNoTo,Qty,Trancode   FROM dtaAFRegisterMst					
    WHERE AFStubID IN (SELECT AFStubID FROM dtaAFRegisterTrn WHERE RepID = ' ' AND AFName = 'AF51')	

Output of the SQL Above
>
> STUBID SampleORFrom SampleORTO QuantityUsed RemainingQuantity
> AF1000003 1 50 50 0
> AF1000004 51 100 50 0



> And I would like to to like this and i dont have any idea to do it

> STUBID SampleORFrom SampleORTO QuantityUsed RemainingQuantity
> AF1000003 21 50 30 20
> AF1000004 61 100 40 10


please help me thanks