Re: Sales Report and Output

Awesome, glad to help! Aggregate functions are your fun and easy friends (SUM, COUNT, MIN, MAX, GROUP BY) ... good stuff. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Tri

Re: Sales Report and Output

Hi jason Thanks for your reply, a few tweaks to my table names and it worked great! Thank you!!! Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.double

re: Sales Report and Output

Not sure of your column names, or where your 'price' value is stored, but I think you want something like what's below. Note that this also will show all your products which may have had '0' orders so far (by using the LEFT join). SELECT gp_product_templates.gp_name, wp_products

Sales Report and Output

Hi I need to do some reporting on orders from a web site, the table structure is as follows; wp_products {ID: wp_products_id JOINED TO wp_products ON ga_product_templates.wp_product_template_id=wp_products.wp_product_template_id} ga_product_templates{ID:gp_id; JOINED TO wp_products ON wp_pro