CREATE OR ALTER VIEW VD_STR(
    ID_CODE,
    ID_OPT_1,
    ID_OPT_2)
AS
SELECT STR.ID_CODE,
       VDOPT_1.VD_OPTCODE||'-'||VDOPT_1.VD_OPTNAME,
       VDOPT_2.VD_OPTCODE

FROM D_STORAGE STR, VD_OPTION VDOPT_1, VD_OPTION VDOPT_2
WHERE
      VDOPT_1.ID_CODE = STR.ID_OPT_1 and
      VDOPT_2.ID_CODE = STR.ID_OPT_2

GROUP BY
       STR.ID_CODE,
       VDOPT_1.VD_OPTCODE||'-'||VDOPT_1.VD_OPTNAME,
       VDOPT_2.VD_OPTCODE
;

CREATE OR ALTER VIEW VD_STR(
    ID_CODE,
    ID_OPT_1,
    ID_OPT_2,
    VS_OPT_1,
    VS_OPT_2
    )
AS
SELECT DSTR.ID_CODE, DSTR.ID_OPT_1, DSTR.ID_OPT_2,
       VDOPT_1.VD_OPTCODE||'-'||VDOPT_1.VD_OPTNAME,
       VDOPT_2.VD_OPTCODE

FROM D_STORAGE DSTR, VD_OPTION as VDOPT_1, VD_OPTION as VDOPT_2
WHERE
      VDOPT_1.ID_CODE = DSTR.ID_OPT_1 and
      VDOPT_2.ID_CODE = DSTR.ID_OPT_2

GROUP BY
       DSTR.ID_CODE, DSTR.ID_OPT_1, DSTR.ID_OPT_2,
       VDOPT_1.VD_OPTCODE||'-'||VDOPT_1.VD_OPTNAME,
       VDOPT_2.VD_OPTCODE
;