Just a question



I have a query that selects profile data for members, if I don't do a select
distinct it gives me a lot of correct values, (unique values) of members
i.e. only one record per member, but every now and then I get duplicate
values for one member, multiple times.



Why does this occure?



I know SELECT DISTINCT is there to remove duplicates, but without SELECT
DISTINCT why would this "mistake" happen?



Any help would be greatly appreciated.



Kind Regards

Carel Greaves




MS Sql Server LazyDBA home page