--Представление №1:
SELECT        dbo.worker.wrk_id, dbo.worker_in_post.post_id, dbo.worker_in_otdel.otdel_id
FROM            dbo.worker LEFT OUTER JOIN
                         dbo.worker_in_otdel ON dbo.worker.wrk_id = dbo.worker_in_otdel.wrk_id LEFT OUTER JOIN
                         dbo.worker_in_post ON dbo.worker.wrk_id = dbo.worker_in_post.wrk_id

--Представление №2:
SELECT        dbo.worker.wrk_id, dbo.worker_in_post.post_id, COUNT(dbo.worker_in_otdel.otdel_id) AS [Количество отделов в которых состоит сотрудник]
FROM            dbo.worker LEFT OUTER JOIN
                         dbo.worker_in_otdel ON dbo.worker.wrk_id = dbo.worker_in_otdel.wrk_id LEFT OUTER JOIN
                         dbo.worker_in_post ON dbo.worker.wrk_id = dbo.worker_in_post.wrk_id
GROUP BY dbo.worker.wrk_id, dbo.worker_in_post.post_id

            var adapterView = new SqlDataAdapter("SELECT * FROM view_1;", connection);
            var dataSet = new DataSet();
            adapterView.Fill(dataSet, "View");
            var bindingSourceView = new BindingSource(dataSet, "View");
            var gridView = new DataGridView();
            gridView.DataSource = bindingSourceView;
            this.Controls.Add(gridView);