Create TABLE Employee

(

Employee_Id INT IDENTITY(1,1),

Employee_Name VARCHAR(128),

Assigned_Manager_ID VARCHAR(8)

PRIMARY_KEY(Employee_ID)

)

    CREATE TABLE MANAGERTable

    (

        Manager_Id VARCHAR(8),

        Manager_Name VARCHAR(128)

        PRIMARY_KEY(Manager_ID)

    )

    SELECT * FROM Employee WHERE  Assigned_Manager_Id = ""