CREATE TABLE VPROPERTIES_TYPES (
    VPROPERTIES_TYPES_ID        DID /* DID = INTEGER NOT NULL */,
    VPROPERTIES_TYPES_NAME      VARCHAR(64),
    VPROPERTIES_TYPES_NAME_ALT  VARCHAR(64),
    VPROPERTIES_TYPES_MASK      VARCHAR(128),
    VPROPERTIES_TYPES_COMMENT   VARCHAR(128),
    VPROPERTIES_TYPES_ERROR     VARCHAR(128),
    USERNAME                    VARCHAR(64),
    DATE_MODIFY                 TIMESTAMP
);



 CREATE TABLE VMED_PROPERTIES (
    VMED_PROPERTIES_ID             DID NOT NULL /* DID = INTEGER NOT NULL */,
    VMED_PROPERTIES_NAME           DNAMESLONG /* DNAMESLONG = VARCHAR(128) */,
    VMED_PROPERTIES_NAME_ALT       DNAMESLONG /* DNAMESLONG = VARCHAR(128) */,
    VMED_PROPERTIES_CLASSES_ID     DID /* DID = INTEGER NOT NULL */,
    VPROPERTIES_TYPES_ID           FID /* FID = INTEGER */,
    VMED_PROPERTIES_DEFAULT_VALUE  DNAMESLONG COLLATE PXW_CYRL /* DNAMESLONG = VARCHAR(128) */,
    USERNAME                       DNAMESSMALL /* DNAMESSMALL = VARCHAR(64) */,
    DATE_MODIFY                    TIMESTAMP
);


CREATE TABLE MED_PROPERTIES (
    VMEDICAMENTS_ID       DID /* DID = INTEGER NOT NULL */, Это код товара
    VMED_PROPERTIES_ID    DID /* DID = INTEGER NOT NULL */,
    MED_PROPERTIES_VALUE  DNAMESSMALL /* DNAMESSMALL = VARCHAR(64) */,
    USERNAME              DNAMESSMALL /* DNAMESSMALL = VARCHAR(64) */,
    DATE_MODIFY           TIMESTAMP
);

...
       left join vmed_properties vp3 on vp3.vmed_properties_name = 'Валюта'
       left join med_properties mp3 on mp3.vmed_properties_id = vp3.vmed_properties_id and
                                    mp3.vmedicaments_id = so.outvmedicaments_id
       left join vmed_properties vp4 on vp4.vmed_properties_name = 'НДС'
       left join med_properties mp4 on mp4.vmed_properties_id = vp4.vmed_properties_id and
                                    mp4.vmedicaments_id = so.outvmedicaments_id
       left join vmed_properties vp5 on vp5.vmed_properties_name = 'Рег. цена'
       left join med_properties mp5 on mp5.vmed_properties_id = vp5.vmed_properties_id and
                                    mp5.vmedicaments_id = so.outvmedicaments_id
...

Аспирин
+- Аспирин 10
|  +- Аспирин Россия
|  |  +- Аспирин московский
|  |  +- Аспирин пермский
|  +- Аспирин заграничный
|     +- Аспирин У ПСА
|     +- Аспирин байеровский
+- Аспирин растворимый

... from vmed_properties vp3 join med_properties mp3
   on mp3.vmed_properties_id = vp3.vmed_properties_id
where mp3.vmedicaments_id = so.outvmedicaments_id
   and vp3.vmed_properties_name in ('Валюта','НДС','Рег. цена')