select t.Name, s.Name as Scenario_Name, s.ProjectedRevenue, s.ExpectedGrossMargin, s.CalculatedGrossMargin, s.CalculatedGrossMargin_LM, s.StartDate, s.EndDate, s.TDDirectCosts, s.TDDirectCosts_LM, s.BUDirectCosts, s.BUDirectCosts_LM, s.CostSavings, s.CostSavingsStartDate, t.id as TeamId, s.CostSavingsEndDate, s.CostSavingsType, p.IsRevenueGenerating, p.Name as Project_Name, p.Priority, p.Probability, p.Deadline, st.Name as Status_Name, p.StatusId AS ProjectStatusId, s.Id as ScenarioId, p.Id as ProjectId from Project p, Scenario s, Team t, Team2Project tp, Status st where t.Id = tp.TeamId and p.Id = tp.ProjectId and s.ParentId = p.Id and st.Id = p.StatusId SELECT Id, Name, Color, IsSystem, Probability100 FROM Status