Hello, I have this scenario. Its an inventory Software I am updating. Finding better ways to do things. I have a main table (tblMainInventory), Sales table (tblSales) and a Receives table (tblReceives). The tblMainInventory is the base table while tblSales and tblReceives interacts with tblMainInventory to always arrive at the quantity in stock at any given time.
Lets say I have: tblMainInventory (ProductNo1) = 40 tblSales (ProductNo1) = 30 tblReceives (ProductNo1) = 20 Balance (ProductNo1) = 30 Now, I want to be able to use the SQL statement to do the above calculation for all the products available (Not just ProductNo1 alone) in one SQL Statement. Is it possible? Best regards, ------------------------------------ Fredrick Ughimi, President Mega-Net Computers (Software Development Company) www.ughimisoft.com supp...@ughimisoft.com fugh...@yahoo.com Phone Nos: 07035682478, 07055630187 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users