prefixes with same name

[melb]

Hello,

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.


Thanks,

Melb

[D. Patrick Hoerter]

melb,

Do you mean use a table or view twice?

If so:

Assume this table:
CREATE TABLE MyTable
(
CustomerID int NOT NULL,
ReferrerID int NOT NULL,
CompanyName int NOT NULL
)

SELECT
Table1.CompanyName AS ReferrerCompanyName,
Table2.CompanyName
FROM
MyTable AS Table1
INNER JOIN MyTable AS Table2 ON
Table2.ReferrerID = Table1.CustomerID

Regards,
D. Patrick Hoerter

melb <boau7158@exact.nl> wrote in message news:3a6dae86$1@news.devx.com...
>
> Hello,
>
> 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.
>
>
> Thanks,
>
> Melb