quote:

---

Originally posted by visakh16

what does that mean?
it gives you distinct combinations of values in those fields

you wont lose anything from the table but it just retrieves distinct from those which are present

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

If you have several fields and a field duplicate values ??will not show.
On the field Put distinct and There is the potential loss of other fields.
As well as the relationship between tables
Usually occurs in the data cleansing.
for Example:


SELECT
distinct[PDC_ProducerName]
,[PDC_BL_CNYTP],[PDC_ID]
,[PDC_Code]

FROM [Root1].[dbo].[TB_Producer]
where [PDC_ProducerName]='chammed'

PDC_ProducerName PDC_BL_CNYTP PDC_ID PDC_Code
chammed 209 9592 NULL
chammed 209 9599 NULL
chammed 175 9600 NULL
chammed 208 9661 NULL


I want to do the same Duplicate name "
PDC_ProducerName"
in the previous database with different codes stored in the same On the other hand off the names of the loss of other codes that may be associated with another table"PDC_BL_CNYTP"

Thanks for your help

---