Re: [sqlite] A simple calculation, complex SQL Statement

2012-01-31 Thread Black, Michael (IS)
[fugh...@yahoo.com] Sent: Tuesday, January 31, 2012 11:20 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] A simple calculation, complex SQL Statement Hello, I have this scenario. Its an inventory Software I am updating. Finding better ways to do things. I have a main table (tblMainInventory

Re: [sqlite] A simple calculation, complex SQL Statement

2012-01-31 Thread Petite Abeille
On Jan 31, 2012, at 6:20 PM, Fredrick Ughimi wrote: > 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? Sure. Join your various tables and group the result set by

[sqlite] A simple calculation, complex SQL Statement

2012-01-31 Thread Fredrick Ughimi
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