|
Posted by Tom Cat on 05/15/06 21:41
That worked great! Never knew about this UNION ALL thing. Thanks!
SQL wrote:
> 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]
|