|
Posted by SQL on 05/15/06 21:30
This should do it
CREATE VIEW AssignedTo
AS
SELECT EmployeeID as ID,FirstName + LastName AS LongName
FROM tblEmployees
UNION ALL
SELECT DeptID,LongName
FROM tlkpDept
Use Query Analyzer not Enterprise Manager I forgot if EM let's you use
UNION
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Navigation:
[Reply to this message]
|