[gjtrd]

Проблему вроде решил, спасибо.

Код:

Create View Kniga (ID, DATA, NAKL, VID, KOL, CENA, NAME, MAT) AS Select DISTINCT B.ID_BOOK AS ID, B.DATA AS DATA, B.DoC AS NAKL, B.Vid AS VID, B.KOL AS KOL, B.PICE_Book AS CENA, P.Name_post AS NAME, M.Name_Mat AS MAT from Book B, Post P, Dept D, Mat M
Where b.Id_post=p.ID_post AND B.ID_dept IS NULL AND b.ID_MAT=m.ID_MAT union all Select DISTINCT B.ID_BOOK AS ID, B.DATA AS DATA, B.DoC AS NAKL, B.Vid AS VID, B.KOL AS KOL, B.PICE_Book AS CENA, D.Name_dept AS NAME, M.Name_Mat AS MAT from Book B, Post P, Dept D, Mat M
Where b.ID_dept=d.ID_DEPT AND B.ID_POST IS NULL And b.ID_MAT=m.ID_MAT;