[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
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
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
3 matches
Mail list logo