oracle8.1.6 select f.param_id, param, case when f.is_required = 't' then 't' else w.is_required end is_required, is_html, nvl(w.value,f.default_value) default_value, nvl(w.param_source,'literal') param_source from cm_form_widget_params f, ( select is_required, param_id, param_source, value from cm_attribute_widget_params awp, cm_attribute_widgets aw where awp.attribute_id = :attribute_id and awp.attribute_id = aw.attribute_id ) w where widget = :widget and f.param_id = w.param_id (+)