Problem 12. Employees with Project ; Table Relations
Колеги, някой може ли да ми покаже кода на Problem 12. Employees with Project ; Table Relations.
Аз стигам само до тук...
use softuni
select distinct e.EmployeeID, e.FirstName , p.Name from employees as e
inner join EmployeesProjects as ep on e.EmployeeID= ep.EmployeeID
inner join Projects as p on p.ProjectID= ep.ProjectID
where StartDate > '2002-08-13'
and EndDate is null
order by EmployeeID
Мина :)
Благодаря!