Help with SUM 1

[dmears1]

I need to pull info from 2 tables and then do a summation on one of the returned rows. Here is the SELECT statement I have which does pull the info I need:

SELECT orders.orders_id, orders.date_purchased, orders_total.class, orders_total.orders_id, orders_total.value
FROM orders, orders_total
WHERE orders.orders_id = orders_total.orders_id AND orders_total.class = 'ot_total' AND orders.date_purchased
LIKE '2004-07%'

How can I do a SUM on the orders_total.value column? I thought I could do this using CREATE VIEW but then realized that you must have MySQL v5 to use CREATE VIEW.
Thanks in advance for any help.

http://www.Morter.com

http://www.BestLifeTraining.com

http://www.AbsoluteStudio.com

 

[r937]

SELECT sum(orders_total.value) as total_value
  FROM orders
inner
  join orders_total
    on orders.orders_id 
     = orders_total.orders_id 
   and orders_total.class = 'ot_total' 
 where orders.date_purchased >= '2004-07-01'
   AND orders.date_purchased  < '2004-08-01'

r937.com | rudy.ca

 

[dmears1]

Thanks r937.
Thanks does just as I'd wanted.

http://www.Morter.com

http://www.BestLifeTraining.com

http://www.AbsoluteStudio.com