Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Ambiguous column name 'col3'

Author  Topic  srad Starting Member 39 Posts Posted - 2001-09-17 : 12:28:43 Why am i getting an ambiguous column error with this syntax? create table #temp( co11 varchar(50) null, co12 varchar(50) null, col3 varchar(50) null ) insert #temp select table1.ID as col1, codedesc, table2.len as col3 from table3 inner join table1 on table3.code = table1.SeriesCode join table2 on table3.lencode = table2.lenid