View Single Post
  #1 (permalink)  
Old May 7th, 2006, 11:56 PM
davwein davwein is offline
Registered User
 
Join Date: May 2006
Location: Indianapolis, IN, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default View example failed

When I attempted to try the view example on page 41

using this code:
CREATE VIEW InventoryPublisherView AS
(SELECT * FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)


I received the following error:

Msg 4506, Level 16, State 1, Procedure IPV, Line 2
Column names in each view or function must be unique. Column name 'ID' in view or function 'IPV' is specified more than once.

I tried using only the code part (in the brackets) - not the view part and the code worked ok. so I am confused as to what went wrong in the view specification.




Reply With Quote