prefixes with same name
I 've got a question;
I want to know whether it is possible to use two prefixes with the same name
in one FROM statement.
Re: prefixes with same name
Do you mean use a table or view twice?
Assume this table:
CREATE TABLE MyTable
CustomerID int NOT NULL,
ReferrerID int NOT NULL,
CompanyName int NOT NULL
Table1.CompanyName AS ReferrerCompanyName,
MyTable AS Table1
INNER JOIN MyTable AS Table2 ON
Table2.ReferrerID = Table1.CustomerID
D. Patrick Hoerter
melb <email@example.com> wrote in message news:firstname.lastname@example.org...
> I 've got a question;
> I want to know whether it is possible to use two prefixes with the same
> in one FROM statement.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL