No Probes...

Follow this:

SELECT select_list
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]

Just .1 cent worth, if u can manage go for some SQL
introductory book , Also BOL available...

All the Best,
San


--- Jaimie Freitas <jaimie.[Email Address Removed] wrote:
> 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
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
MS Sql Server LazyDBA home page