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: > > > select > email_blast.embl_email,email_blast.embl_companyname,email_blas > t.embl_name,email_results.emres_prod_part_numl,email_results.emre > s_

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  

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, That

RE: Group By Question

2003-11-25 Thread Ben Densmore
ED] companyA [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 que

RE: Group By Question

2003-11-25 Thread Dave Watts
>  I have a query that currently looks like: > > > 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 > email_blas_id = emres_blast_email_id > Group By email_blast.embl_emai

Group By Question

2003-11-25 Thread Ben Densmore
Hi, I have a query that currently looks like: 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 email_blas_id = emres_blast_email_id Group By email_blast.embl_email ORDER BY em