View: core.compound_unit_scrud_view

 CREATE OR REPLACE VIEW core.compound_unit_scrud_view
 AS
 SELECT compound_units.compound_unit_id,
    base_unit.unit_name AS base_unit_name,
    compound_units.value,
    compare_unit.unit_name AS compare_unit_name
   FROM core.compound_units,
    core.units base_unit,
    core.units compare_unit
  WHERE compound_units.base_unit_id = base_unit.unit_id AND compound_units.compare_unit_id = compare_unit.unit_id;