Re: GROUP BY...
From: Dominique Javet (kidhermes_at_yahoo.fr)
Date: 05/06/04
- Next message: Brad Kent: "openssl_pkey_new()"
- Previous message: Web Master: "Jacks php from mail script"
- In reply to: Erwin Moller: "Re: GROUP BY..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 6 May 2004 17:33:59 +0200
Hello,
Correct, I don't have included GROUP BY because I dont have a interessant
result with...
So I think it's better to not include something incomplete.. no?
I still now the GROUP BY synthax (and the site you gave me), but I wish to
group 1 colmn and a another and it's not alphabetical...
BTW, thx, I'm still looking.
Regards, Dom
"Erwin Moller"
<since_humans_read_this_I_am_spammed_too_much@spamyourself.com> wrote in
message news:409a589c$0$561$e4fe514c@news.xs4all.nl...
> Dominique Javet wrote:
>
> > Hello,
> >
> > I've a little problem with GROUP BY for my query:
> >
> > SELECT
> > `rel_experience_client`.`client_ref`,
> > `client`.`id`,
> > `rel_experience_client`.`experience_ref`,
> > `experience`.`id` AS `id1`,
> > `experience`.`titre_fr`,
> > `client`.`libelle`
> > FROM
> > `rel_experience_client`
> > INNER JOIN `client` `client1` ON (`rel_experience_client`.`client_ref` =
> > `client1`.`id`)
> > INNER JOIN `experience` ON (`rel_experience_client`.`experience_ref` =
> > `experience`.`id`)
> > RIGHT OUTER JOIN `client` ON (`rel_experience_client`.`client_ref` =
> > `client`.`id`)
> > ORDER BY
> > `client`.`libelle`
> >
> > Here's the result:
> > -> http://www.metadelic.com/rapport.htm
> >
> > And here's what I wish to have without including the colmn "client_ref"
> > for the result:
> > -> http://www.metadelic.com/rapport.htm#result
> >
> > I can't work it out...
> > Any suggestion on how to do?
> >
> >
> > Regards, Dom
>
>
> Hi Dominique,
>
> What is it that you want?
> You example is completely unclear to me.
> In your posting you use ORDER BY, but in your topic you use GROUP BY.
> These two are completely unrelated SQL commands.
>
> If you use a GROUP BY, you need to define at least ONE AGRREGATE in your
> query, which you didn't.
>
> Please have a look at: http://www.w3schools.com/sql/default.asp for a very
> good quick introduction to SQL. Both GROUP BY and ORDER BY are covered in
> that tutorial. It is a great SQL primer.
>
> I am sure you can rewrite your query after reading that tutorial so it
will
> do what you want.
>
> Good luck!
>
> Regards,
> Erwin Moller
- Next message: Brad Kent: "openssl_pkey_new()"
- Previous message: Web Master: "Jacks php from mail script"
- In reply to: Erwin Moller: "Re: GROUP BY..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
