Return non duplicate records

[Julian]

Hi

I have this query:
$query_list = "SELECT edicion.id_edicion AS id_edicion, volumen.volumen AS volumen, edicion.id_volumen AS id_volumen, edicion.title AS title, edicion.edicion AS edicion, edicion.main AS main ";
$query_list .= "FROM edicion ";
$query_list .= "INNER JOIN volumen ON edicion.id_volumen=volumen.id_volumen ";
$query_list .= "ORDER BY edicion ASC ";

What I'm missing here is that I want to show only records that are different in `edicon` column.

Thanks for the help.

[joquius]

SELECT DISTINCT `field` FROM...
this is what you mean?

[Psycho]

$query_list = "SELECT edicion.id_edicion AS id_edicion, volumen.volumen AS volumen, edicion.id_volumen AS id_volumen, edicion.title AS title, edicion.edicion AS edicion, edicion.main AS main ";
$query_list .= "FROM edicion ";
$query_list .= "INNER JOIN volumen ON edicion.id_volumen=volumen.id_volumen ";
[b]$query_list .= "GROUP BY edicion";[/b]
$query_list .= "ORDER BY edicion ASC ";

[Julian]

Thanks mjdamato

That is what I was looking for.  Worked great