Most likely one or more of your joins produces that effect

-----Original Message-----
From: Carel Greaves
[mailto:mssqldba-ezmlmshield-x25494975.[Email address protected]
Sent: Friday, August 31, 2007 10:39
To: LazyDBA Discussion
Subject: Select Distinct Values

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





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page