iBase.ru Forum

Код: Выделить всё

CREATE VIEW VIEW_ITEMSVSKOL(
    ID_CODE,
    VI_GROUP,
    VI_NAME,
    VI_CODE,
    VI_IZM,
    VI_PLACE,
    VI_MIN,
    VI_PRICEPROD,
    VI_KOL)
AS
SELECT
    It.ID_CODE,
    Gr.G_GROUP,
    It.I_NAME,
    It.I_IDENT,
    It.I_IZM,
    It.I_PLACE,
    It.I_MIN,
    It.I_PRICEPROD,
    Sum(Src.S_KOL)
FROM
   C_ITEMS It, C_GROUPS Gr, SOURCE Src
WHERE
   Gr.ID_CODE = It.ID_GROUP AND
   Src.ID_ITEM = It.ID_CODE
GROUP BY
    It.ID_CODE,
    Gr.G_GROUP,
    It.I_NAME,
    It.I_IDENT,
    It.I_IZM,
    It.I_PLACE,
    It.I_MIN,
    It.I_PRICEPROD
;