> 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_
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
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
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
> 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
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
6 matches
Mail list logo