Avoid Duplication

[virusisfound]

Hi,

I am working on one inventory control project in that I have one combo box in the combo box I am showing all the product name but in database their is duplication of product name when user sale one product then it save in the table. So the user sale one product for 3 times then it displays three time name in the combo box. I want to show only once time product name.

Is their is any solution for this problem.

[__avd]

Use SELECT DISTINCT clause.

SELECT DISTINCT ProductName FROM TABLE

Or - use GROUP BY.