Books online Jamie...... hit F1 when you are in Query Anal-yzer, that
should Rect-ify the situation.

It's got me out of all sorts of trouble.

Regards
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988




sanjeev gupta
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
hoo.com> cc:
bcc:
25/04/2003 Subject: RE: Stupid Question
06:19 PM






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] you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] information contained in this email and any attached files is strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Aon Risk Services Australia, Aon Consulting, Aon Re Australia Ltd and other associated Aon Companies on +61 2 92537000 and promptly delete this email and any attachments.

The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Aon's permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files.

Aon advises that this email and any attached files should be scanned to detect viruses. Aon accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files."
**********************************************************************

MS Sql Server LazyDBA home page