SQL

Combos for a component with type

select combo.*, rdv.rdv_value from combo, refdata_value rdv where combo_from_fk = COMPONENT_ID or combo_to_fk = COMPONENT_ID and combo_type_rv_fk = rdv.rdv_id;