View From A Merge Of Two Tables

Hi,

I hope this is the right place to ask this question. If it is not,
please let me know a more appropriate place.

I have two tables.

CREATE TABLE tblEmployees
(
EmployeeID int identity NOT NULL,
LastName varchar(50) NULL,
FirstName varchar(50) NULL,
);

CREATE TABLE tlkpDept
(
DeptID char(5) NULL,
Name char(10) NULL,
LongName char(50) NULL
);

Now I want to create a view called AssignedTo. [The application I'm
doing, will track the status of our customer requests. Each request
can be assigned to either an individual employee or an entire
department]

I want the view to have two columns, ID and LongName. ID should be
either the DeptID or the EmployeeID. The LongName column should be
either the LongName or the FirstName + LastName.

I'm not even sure how to begin to write such a complex SQL.
EnterpriseManager is being less than helpful too.

Can anyone help?

Thanks in advance.

-Tom