Thanks for your help
I have another stupid question (sorry im new to all this and thrown in at
the deep end)
I need to add data to that query how do I do that?
i.e. I need the address, company name, post code and so on
I apologise for my stupidity in advance!
Kindest regards
Jaimie


> -----Original Message-----
> From: Jaimie Freitas
> Sent: 24 April 2003 14:06
> To: 'LazyDBA. com Discussion' (E-mail)
> Subject: Stupid Question
>
> Hi I need a query that will return all the unique customer names from a
> table.
>
> I have a database full of duplicates and only want to the name to appear
> once in the query as opposed to 10 times!
>
> Thanks for any help in advance
>
> Kind regards
>
> Jaimie
>
>
The contents of this e-mail are strictly confidential and are intended only
for the addressee named above. This e-mail may contain confidential or
privileged information. If you are not the intended recipient of this
message please notify the sender immediately. The contents of this e-mail
must not be disclosed to any other person or copies taken. Please note that
any views expressed in this e-mail may be those of the originator and do not
necessarily reflect those of this organisation. Internet e-mail is not a
secure communications medium. Please note this lack of security when
responding by e-mail. Accordingly we give no warranties or assurances about
the security and content of this e-mail and its attachments. Neither Thermo
Electron Corporation nor the sender accepts any responsibility or liability
for viruses and it is your responsibility to scan the e-mail and
attachments. Any liability arising from any third party acting on any
information contained in this e-mail is hereby excluded. (c) Thermo
Electron Corporation www.thermo.com
MS Sql Server LazyDBA home page