View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 06:13 AM
robboll
 
Posts: n/a
Default What's wrong with this View? Duplicate columns?

When I add this code in a view and try to save . . .

SELECT TOP 610 *
FROM dbo.Master INNER JOIN
dbo.TypeByCase ON dbo.TypeByCase.CaseNum = dbo.Master.CaseNum

It gives the error:
ODBC error: [Microsoft][ODBC SQL Server Driver]Column names in each
view or function must be unique. Column name 'CaseNum' in view or
function 'dbo.BobView1' is specified more than once.

Any idea why?

Thanks,

RBollinger

Reply With Quote