2 23qwerty Addict Joined Jul 13, 2016 Posts 34 Reaction 2 Points 74 Aug 14, 2018 #1 paano yung sa 2 tables na nagkacount yung column tas pagmamayminusin pareho para makita yung items remaining
paano yung sa 2 tables na nagkacount yung column tas pagmamayminusin pareho para makita yung items remaining
M mrHazan Forum Veteran Aug 14, 2018 #2 Bale yung table 1 is StoredQuantity tapos yung isa eh SoldQuantity? Kunin yung difference para makuha yung natitira?
Bale yung table 1 is StoredQuantity tapos yung isa eh SoldQuantity? Kunin yung difference para makuha yung natitira?
2 23qwerty Addict Aug 14, 2018 TS TS #3 mrHazan said: Bale yung table 1 is StoredQuantity tapos yung isa eh SoldQuantity? Kunin yung difference para makuha yung natitira? Click to expand... Salamat boss my sample codes ka
mrHazan said: Bale yung table 1 is StoredQuantity tapos yung isa eh SoldQuantity? Kunin yung difference para makuha yung natitira? Click to expand... Salamat boss my sample codes ka
M mrHazan Forum Veteran Aug 14, 2018 #4 23qwerty said: Salamat boss my sample codes ka Click to expand... Hindi ko alam structure ng DB mo pero ang kailangan mo lang eh SELECT query. Select mo sa DB mo yung item using name o id ilagay mo sa variable tapos minus mo. Ano nagawa o progress mo? Pakita mo para maguide kita.
23qwerty said: Salamat boss my sample codes ka Click to expand... Hindi ko alam structure ng DB mo pero ang kailangan mo lang eh SELECT query. Select mo sa DB mo yung item using name o id ilagay mo sa variable tapos minus mo. Ano nagawa o progress mo? Pakita mo para maguide kita.
2 23qwerty Addict Aug 16, 2018 TS TS #5 mrHazan said: minus Click to expand... Boss ito po yung 1st tbl SELECT COUNT(inv_ItemCode) FROM fc_inventory, fc_cashier WHERE csh_ItemCode = inv_ItemCode GROUP BY csh_ItemCode , inv_ItemCode 2nd tbl SELECT COUNT(csh_ItemCode) FROM fc_cashier GROUP BY csh_ItemCode Yan naman po yung error Attachments You do not have permission to view the full content of this post. Log in or register now.
mrHazan said: minus Click to expand... Boss ito po yung 1st tbl SELECT COUNT(inv_ItemCode) FROM fc_inventory, fc_cashier WHERE csh_ItemCode = inv_ItemCode GROUP BY csh_ItemCode , inv_ItemCode 2nd tbl SELECT COUNT(csh_ItemCode) FROM fc_cashier GROUP BY csh_ItemCode Yan naman po yung error
R rehpej Honorary Poster Sep 1, 2018 #6 try mo po sa C# na mag minus. kunin mo yung value ng datatable after mo mag select count.
F fazz12 Honorary Poster Sep 1, 2018 #7 sa code (c#) ka mas madaling makakapagsubtract kesa sa script(sql). sa script fetch ka lang ng fetch. sa code ka maglologic
sa code (c#) ka mas madaling makakapagsubtract kesa sa script(sql). sa script fetch ka lang ng fetch. sa code ka maglologic