Does the following view have a "self join", and if not, why can't an indexed
view be created?

create table t1 (i int, j int)
create table t2 (i int)
go

create view v1 with SCHEMABINDING
as
select t1.i from
dbo.t1 join dbo.t2 on t1.i = t2.i join dbo.t2 t3 on t3.i=t1.i
go

create unique clustered index ci on v1(i)


--
Kevin Connell, MCDBA
--------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------

Yes, you have a self join. You specify the table t2 twice in the FROM clause, giving it different
alias names.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


"Kevin" <ReplyTo (AT) Newsgroups (DOT) only> wrote