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:
-> [url]http://www.metadelic.com/rapport.htm[/url]

And here's what I wish to have without including the colmn "client_ref" for
the result:
-> [url]http://www.metadelic.com/rapport.htm#result[/url]

I can't work it out...
Any suggestion on how to do?

Regards, Dom

[Janwillem Borleffs]

"Dominique Javet" <kidh...@yahoo.fr> wrote in message
news:2fuqnbF...@uni-berlin.de...

> And here's what I wish to have without including the colmn "client_ref"
for
> the result:
> -> [url]http://www.metadelic.com/rapport.htm#result[/url]
>

Use concat e.g.:

SELECT CONCAT(fielda, '#', fieldb) as url ...

JW