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.
| Author |
Topic |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2006-07-17 : 14:20:53
|
| I am trying to create a view but I get this errorThe column '' was specified multiple times for '[view name]'.Query analyzer returns the correct data but I cannot make a view. It has three subqueries. Nothing in MS kb about this error.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-17 : 14:23:51
|
| You are probably using aggregate functions but have not provided names for these columns. You need to provide an alias for them. If you need help with this, then please post your code.Tara Kizer |
 |
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2006-07-17 : 17:00:55
|
| You were on the right track. For the fields I had in the subqueries, I put the 'as ABC' in the subquery select list. I moved it outside the subquery and it worked.Thanks |
|
|
|
|
|
|
Error 8156: the column ' ' was specificed