[djavet]

Hello,

I've a little problem with GROUP BY for my query:

PHP Code:

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

[NeverMind]

well, what is the problem exactly?
the links you gave show identecial results !