Sort table with quarry

[senaka]

Hi all,
i just get in to this world, i apologize all mistake i might do.

i have tow tables, one

ID order Qty
1 500 1
2 500-1 2
3 400 1

2nd table

order_id status
500 ok
500-1 ok
500-1 ok
400 ok

i wanna wright quarry how many qty finish from table one. table tow get information out of scanning. if you see table tow i have tow rows 500-1 because of tow Qty, wen i wanna see result i would line to see how many Qty done so far.

Thank you in advanced.

[UnklDonald418]

Welcome to the the forum.
Sorry but the structure of your tables isn't clear, but it appears you want to generate a running total. That requires a sub query something like

Code: Select all

SELECT "TA"."ID", "TA"."Qty"
, (SELECT SUM("S"."QTY") FROM "TableA" AS "S" WHERE "S"."ID" <= "TA"."ID")  AS "Running Total" 
FROM "TableA" AS "TA"

If you need further help with this please upload a sample database.
viewtopic.php?f=74&t=8289