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
;