Need Help Writing A Custom View In Sql Server

Does anyone know
if the following sql view is possible to write and execute as a view script?

 



**********
find employee matching the given UserID*************
    
SELECT
  * FROM Employees WHERE EmployeeID=@UserID

 

***********
find client matching the given ClientID**********
    
SELECT *
FROM Clients WHERE ClientID=@ClientID

 





**********find
all contacts and events associated with ClientID*********
     
SELECT *
FROM Contacts WHERE Contact.ClientID=@ClientID
SELECT *
FROM Events WHERE Event.ClientID=@ClientID

 

*********select
all audits with Key values matching the primary keys of each client, contact or
event*********
SELECT *
FROM Audit Where Key In (Client.ClientID, Contact.ContactID, Event.EventID)

 I basically
need to find a employee based on its ID.
  Then I need to find any records from the table Audit
with Key values matching the given fields in the results of any clients, contacts events that were returned from the previous select statements.  Is this possible?