[RESOLVED] Select Distinct

[garfx]

Hi all

I am useing the query below can someone please tell me how i can use the SELECT DISTINCT command and still rename a column ie "label.id AS lid" but exculde this from the SELECT DISTINCT

"SELECT DISTINCT label, labels.id AS lid FROM labels INNER JOIN titles ON titles.label_id = labels.id WHERE titles.export = 1 ORDER BY label"

thank you

Gareth

[bogu]

Try this one:

SELECT label, labels.id AS lid 
FROM labels 
INNER JOIN titles ON titles.label_id = labels.id 
WHERE titles.export = 1 
GROUP BY label
ORDER BY label