Export (0) Print
Expand All
Expand Minimize
1 out of 28 rated this helpful - Rate this topic

View definition includes no output columns or no items in the FROM clause.

A view definition must have at least one table or table-structured object in the FROM clause, and must have at least one column in the select list. The view definition is missing one or both. Modify the view definition accordingly.

The following example is a simple view definition. The select list contains four columns and the FROM clause references two tables.

CREATE VIEW hiredate_view
SELECT c.FirstName, c.LastName, e.EmployeeID, e.HireDate
FROM HumanResources.Employee AS e 
JOIN Person.Contact c on e.ContactID = c.ContactID;
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.