RE: Group By Question

2003-11-25 Thread Dave Watts
I have a query that currently looks like: CFQUERY name=clicks_per_product_market_display datasource=# Data_Source # select * from email_results, email_blast Where email_results.emres_blast_sent_id = #URL.BLAST# AND email_results.emres_prod_catagory = '#get_cat_info.Category#' AND

RE: Group By Question

2003-11-25 Thread Ben Densmore
[EMAIL PROTECTED] I want companyA to show up only once even if they clicked 5 times. Does that make sense? Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 11:43 AM To: CF-Talk Subject: RE: Group By Question I have a query that currently

RE: Group By Question

2003-11-25 Thread d.a.collie
Why are you using GROUP BY if you dont have any aggregate functions in your select clause (ie AVG() SUM() etc). Try taking it out -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 25 November 2003 16:45 To: CF-Talk Subject: RE: Group By Question Dave

Re: Group By Question

2003-11-25 Thread David Fafard
use MAX(columnname) as alias along with your grouping. dave - Original Message - From: Ben Densmore To: CF-Talk Sent: Tuesday, November 25, 2003 11:44 AM Subject: RE: Group By Question Dave, That doesn't seem to do what I want it to. I modified the query to grab just the fields I'm

RE: Group By Question

2003-11-25 Thread Dave Watts
That doesn't seem to do what I want it to. I modified the query to grab just the fields I'm using and grouped by those fields: CFQUERY name=clicks_per_product_market_display datasource=# Data_Source # select email_blast.embl_email,email_blast.embl_companyname,email_blas