GROUP BY...

[Dominique Javet]

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

[Erwin Moller]

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

[Dominique Javet]

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"
<si******************************************@spam yourself.com> wrote in
message news:40*********************@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