MonsterRocks (11/22/2010)

---

create table #table1 (col1 int,col2 varchar(30))

insert into #table1 values (1,'martin')

insert into #table1 values (2,'tom')

insert into #table1 values (3,'schrof')

create table #table2(t_col1 int identity(1,1),t_col2 int)

create table #table3 (f_col1 int identity(1,1),f_col2 varchar(30),f_col3 int)

insert into #table2 (t_col2) output inserted.t_col1,t.col1 into #table3(f_col2,f_col3) select col1 from #table1 t

i am getting folowing error

The multi-part identifier "t.col1" could not be bound.

what could be the problem?...any suggestion pls