> Hi all
>
> i have an sql 2005 database with stock table containing stock part and stock name
> i faced a duplication problem with this table
>
> how can i delete one of the duplicate and keep th other one
>
> b.regards
> zakaria
> foxes wil always be running
You could use union.
Cetin Basoz