values in pick list

[TESS_GEAR]

<cfquery name="getValue" datasource="testdata">
select c.colorname, r.relatedcolor, o.relatedobject
from Color.c INNER JOIN SimilarColor s
ON c.colored = s.index_id
INNER JOIN ObjectColor o
ON s.objected = o.index_id
</cfquery>

Color Description:
<select id="ColorDescript" name="ColorDescript">
<cfoutput query="getValue">
<cfset variables.SDNF = "#getValue.colorname##getValue.relatedcolor##getValue.relatedobject#">
<option value="#getValue.SDNF#">#variables.SDNF#
</cfoutput>
</select>

if i run the code, the list of color description shows duplicated records.
such as

RedOrangeTabe
RedOrangeTabe
RedOrangeTabe
RedOrangeTabe
BlueGreenChair
BlueGreenChair
PurpleGreenKeyboard
PurpleGreenKeyboard
PurpleGreenKeyboard
PinkYellowCap
PinkYellowCap
PinkYellowCap

Is there any way i can list one value instead of duplicated values in the pick list?

expected list is as below:

RedOrangeTabe
BlueGreenChair
PurpleGreenKeyboard
PinkYellowCap

[Dan_Bracuk]

cfdump your query. Do you have duplicates in your db?