sql server programming: What is the meaning of this Select Statement -- sql server programming

What is the meaning of this Select Statement

hon123456
10/21/2007 7:54:01 PM

sql server programming:

Dear All,

I have a select statement as follows:

select * from tableA tableB where TableA.field1 = "test"

I do not understand Where is the meaning of TableA TableB .
There is no comma between
TableA and Table B. I guess it may be some kind of
Subquery. Please suggest me
what is the meaning of "select * from tableA tableB"

Re: What is the meaning of this Select Statement

Andrew J. Kelly
10/21/2007 8:23:17 PM

tableB in this case is used as an ALIAS to tableA. This is just one reason
why I always recommend using the AS clause when aliasing an object. This
would have been a cleaner implementation.

select * from tableA AS b where b.field1 = "test"

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

[quoted text, click to view]

Re: What is the meaning of this Select Statement

Stephany Young
10/22/2007 12:00:00 AM

Does it work?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.