Hi..
I have the following query.. missing something based on 'net searches. but
how do i create a "group" to allow me to get a single "row"/count based on
the 'd1_status.dept_id'
i can't figure out exactly where in the query to have the "count(*) xxx
group by abc"... the few different approaches i
On Jan 31, 2008 1:30 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> That's rather what I feared. I'm trying to avoid code, mostly because this
> should be a one-off run.
If it's a one-shot deal and you don't mind it taking a little time, I
think something like this would work:
SELECT customers.e
uary 31, 2008 12:09 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: GROUP question
>
> On Jan 30, 2008 5:25 PM, Jerry Schwartz <[EMAIL PROTECTED]>
> wrote:
> > The problem starts when I try to fetch the memos. I want one email
> address,
> &g
On Jan 30, 2008 5:25 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> The problem starts when I try to fetch the memos. I want one email address,
> two or more customer_ids (so I can tell them apart), and all of the memos
> for each customer_id (preferably using GROUP_CONCAT(). In other words, this
I have two tables that (simplified) look like this:
customers
=
customer_id [integer, autoincrement]
email [varchar]
memos
=
memo_id [integer, autoincrement]
customer_id [integer]
memo_text [varchar]
There are some duplicate email addresses in the "customers" table. A
customer might
