[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

tables alias name

Sundara Murthy

3/29/2007 3:40:00 AM

Hi sir,

in sqlserver enterprise manager while writing a sql Qury it showing like this

select * from emp_master emp_master1

how to avoid the emp_master1 in the above said query

thanks

regards
sundara Murthy
1 Answer

Aaron [SQL Server MVP]

3/29/2007 3:49:00 AM

0

Use Query Analyzer, which doesn't try to modify your code.

--
Aaron Bertrand
SQL Server MVP
http://www.sq...
http://www.aspfa...





"Sundara Murthy" <SundaraMurthy@discussions.microsoft.com> wrote in message
news:90212DBD-0D95-4ADD-9FE1-A12500553648@microsoft.com...
> Hi sir,
>
> in sqlserver enterprise manager while writing a sql Qury it showing like
> this
>
> select * from emp_master emp_master1
>
> how to avoid the emp_master1 in the above said query
>
> thanks
>
> regards
> sundara Murthy