select 'Defects' as Type, DefectID as ID, Projects.Name as Project,
                                Users.FirstName + ' ' + Users.LastName as AssignedTo, 
                                StatusTypes.Name as Status, defects.Name 
                from defects, projects, users, StatusTypes
                where Defects.StatusTypeID <> 6
                and Defects.ProjectID = Projects.ProjectID
                and Defects.AssignedToID = Users.UserID
                and Defects.StatusTypeID = StatusTypes.StatusTypeID
union
select 'Features' as Type, FeatureID as ID, Projects.Name as Project ,
                                Users.FirstName + ' ' + Users.LastName as AssignedTo, 
                                StatusTypes.Name as Status, features.Name  
                from features, projects, users, StatusTypes
                where features.StatusTypeID <> 6
                and features.projectid = projects.projectid
                and features.AssignedToID = Users.UserID
                and features.StatusTypeID = StatusTypes.StatusTypeID
union
select 'Incidents' as Type, IncidentID as ID, Projects.Name as Project, 
                                Users.FirstName + ' ' + Users.LastName as AssignedTo, 
                                StatusTypes.Name as Status, incidents.Name 
                from incidents, Projects, Users, StatusTypes
                where incidents.StatusTypeID <> 6
                and incidents.projectid = projects.projectid
                and Incidents.AssignedToID = Users.UserID
                and Incidents.StatusTypeID = StatusTypes.StatusTypeID
union
select 'Task' as Type, TaskID as ID, Projects.Name as Project, 
                                Users.FirstName + ' ' + Users.LastName as AssignedTo, 
                                'Open' as Status, tasks.Name 
                from tasks, projects, Users, StatusTypes
                where IsCompleted  = 0
                and tasks.projectid = projects.projectid
                and Tasks.AssignedToID = Users.UserID
Order by assignedto