android - Fetch Data of two tables and insert to new table

Question

I have three activities in my application with following names:
Activity #1
Activity #2
Activity Final

Also for each activity, I have a table with following names:
Table #1
Table #2
Table Final

Default value of Qty column is "0" and users will change it at run-time.

I've created Table#1 and Table#2 and they work fine.

I just don't know how can I add rows of Table#1 and Table#2 where "Qty" is bigger than "0" into Table Final.

Note: id column of each tables is PRIMARY KEY AUTOINCREMENT

Answer 1

INSERT INTO "Table Final"(Product, Qty)
SELECT Product, Qty FROM "Table #1" WHERE Qty > 0
UNION ALL
SELECT Product, Qty FROM "Table #2" WHERE Qty > 0;