Brian,
>can someone post
a snippit
on Summing tables together of a feild of the
>entire Database ?
Do you mean summing
all row
values of a column in a table, grouped by the value of another column?
If so, for example to
retrieve all electprojcost, electprojbilling values and their
differences per
projectname would be ...
SELECT
projectname,
SUM(electprojcost),
SUM(elecprojbilling),
SUM(elexprojcost-electprojbilling)
AS margin
FROM orders
GROUP BY projectname;
Or
do you mean something else?
PB
-----
Brian E Boothe wrote:
can
someone post a snippit on Summing tables together of a feild of the
entire Database ? why does everyone Have such a problem with this
question? everyone i ask says the same thing,, let me show what i'm
needing by Visual representation
MySQL database >> workorders
Table : Orders
Field(aa) ProjectName -- [enter Projectname]
Field [a] ElecprojCost ----- <-Enter in
Number
Field [b] ElecprojBilling -----<-Enter in
Number
Field [c] Elecprojremaining = [a] - [b]
Field [d] CtrlprojCost ----- <-Enter in
Number
Field [e] CtrlprojBilling ----- <-Enter
in Number
Field [f] Ctrlprojremaining = [d] - [e]
Field [g] OtherprojCost ----- <-Enter in
Number
Field [h] OtherprojBilling -----
<-Enter in Number
Field [i] Otherprojremaining = [g] - [h]
Field [j] BondedAmount = <-Enter in Number
Field [k] Bondedprogbilling = <-Enter in Number
Field [l] Bondedprogremaining = <-= [j] - [ k ]
Field [m] totalelecworkonhand = <-sum of all remaining = (sum of
C all sum records for Values of (C)
Field [n] totalCtrlworkonhand = <-sum of all remaining = (sum of
F all sum records for Values of (F)
Field [o]totalOtherworkonhand = <-sum of all remaining = (sum of
i all sum records for Values of (i)
Field [p] totalworkonhand = m + n + o
Field [Q] totalBondedworkonhand = sum of all remaining = (sum of P
all sum records for Values of (P)
Any help in all this would be greatly appreaciated,, u can
also email me via [EMAIL PROTECTED]
|
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release Date: 3/26/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]