Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Mathematics in mySQL
SELECT p.name, p.qty_in, p.cost_in, p.amount_in, oi.cost_out AS costs_out, oi.qty_out, oi.cost_out * oi.qty_out AS total_out, ( p.qty_in - oi.qty_out ) AS Qty_Balance, ( p.cost_in - oi.cost_out) AS cost_balance, (p.qty_in - oi.qty_out) * ( p.cost_in - oi.cost_out) AS Amount_Balance FROM...
