|
select
w.name as wname, d.name as dname и.т.д.
from
workers w
left join Deptartments d on (d.DeptID=w.DeptID)
left join Roles r on (r.RoleID=w.RoleID)
group by w.DeptID
Вот маленький пример, но, не тестил, от руки писал
__________________
There is no fate but what we make for ourselves.
|