Re: GROUP question

2008-01-31 Thread Perrin Harkins
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

RE: GROUP question

2008-01-31 Thread Jerry Schwartz
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

Re: GROUP question

2008-01-31 Thread Perrin Harkins
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