Форум программистов [Powered by Invision Power Board]

Код

CREATE VIEW VW_FOUNDED(
    ID,
    LCD,
    INPUT_DATE,
    ROOMS_Q,
    ROOMS_HO,
    AREA_S,
    AREA_G,
    AREA_I,
    AREA_K,
    FLOOR,
    FLOORS,
.....
AS
--Квартиры, дома, новостройки
--                     ID,   LCD,   INPUT_DATE,   ROOMS_Q, ROOMS_HO,  AREA_S,   AREA_G,   AREA_I,   AREA_K,   FLOOR,   FLOORS,   PRICE,   HOUSE_NUM,   KORP_NUM,   APART_NUM,   IS_PHONE,  IS_REFRIGERATOR,  IS_TV,  IS_FURNITURE,   ORIENTIR,   REMARK,   REMARK2,   BALCONY,   BALCONY_GLASS,   DATE_LETTING,   DELETED,   ID_TYPE,   ID_REGION,   ID_STREET,   ID_MATERIALS,   ID_SERVICE,   ID_RAZDEL,   ID_GAZ,   ID_UNDERGROUNDSTATION,   ID_STATE,   ID_EX,   ID_FIRMA_BUILD,   FIRMA_BUILD_NAME,   STATE_NAME,   UNDERGROUNDSTATION,   NAME_IS,    REGION_NAME,   STREET_NAME,   SERVICE_NAME,   PLANIROVKA,   MATERIAL_NAME,   GAZ_NAME,   TYPE_NAME,   EXLUSIVE_NAME,   PHONES_LIST)
SELECT               A.ID, A.LCD, A.INPUT_DATE, A.ROOMS_Q,     null,    null, A.AREA_G, A.AREA_I, A.AREA_K, A.FLOOR, A.FLOORS, A.PRICE, A.HOUSE_NUM, A.KORP_NUM, A.APART_NUM, A.IS_PHONE,             NULL,   NULL,          NULL, A.ORIENTIR, A.REMARK, A.REMARK2, A.BALCONY, A.BALCONY_GLASS, A.DATE_LETTING, A.DELETED, A.ID_TYPE, A.ID_REGION, A.ID_STREET, A.ID_MATERIALS, A.ID_SERVICE, A.ID_RAZDEL, A.ID_GAZ, A.ID_UNDERGROUNDSTATION, A.ID_STATE, A.ID_EX, A.ID_FIRMA_BUILD,            FB.NAME,      ST.NAME,               U.NAME,    I.NAME,         R.NAME,        S.NAME,       SRV.NAME,    RAZD.NAME,          M.NAME,     G.NAME,      T.NAME,          EX.NAME, A.PHONES_LIST

FROM APART A
     LEFT JOIN INFOSOURCE           I       ON (A.ID_INFOSOURCE = I.ID)
     LEFT JOIN REGIONS              R       ON (A.ID_REGION = R.ID)
     LEFT JOIN STREETS              S       ON (A.ID_STREET = S.ID)
     LEFT JOIN SERVICES             SRV     ON (A.ID_SERVICE = SRV.ID)
     LEFT JOIN RAZDEL               RAZD    ON (A.ID_RAZDEL = RAZD.ID)
...

--Посредники
union
--                          ID,   LCD,   INPUT_DATE,   ROOMS_Q,   ROOMS_HO, AREA_S,   AREA_G,   AREA_I,   AREA_K,   FLOOR,   FLOORS,   PRICE,   HOUSE_NUM,   KORP_NUM,   APART_NUM,   IS_PHONE,  IS_REFRIGERATOR,  IS_TV,  IS_FURNITURE,   ORIENTIR,   REMARK,   REMARK2,   BALCONY,   BALCONY_GLASS,   DATE_LETTING,      DELETED,   ID_TYPE,   ID_REGION,   ID_STREET,   ID_MATERIALS,   ID_SERVICE,   ID_RAZDEL,   ID_GAZ,   ID_UNDERGROUNDSTATION,   ID_STATE,   ID_EX,   ID_FIRMA_BUILD,   FIRMA_BUILD_NAME,   STATE_NAME,   UNDERGROUNDSTATION,   NAME_IS,    REGION_NAME,   STREET_NAME,   SERVICE_NAME,   PLANIROVKA,   MATERIAL_NAME,   GAZ_NAME,   TYPE_NAME,   EXLUSIVE_NAME,     PHONES_LIST)
  SELECT                MED.ID,  null,         null,      null,       null,   null,     null,     null,     null,    null,     null,    null,        null,        null,       null,       null,             null,   null,          null,       null,     null,      null,      null,            null,           null,  med.DELETED,         8,        null,        null,           null,         null,        null,     null,                    null,       null,    null,             null,               null,         null,                 null,      null,       MED.NAME,          null,           null,         null,            null,       null,        null,            null, MED.PHONES_LIST

from MEDIATORS MED
...
и т.д.