postgresql7.1 select package_key, acs_object__name(package_id) as instance_name from apm_packages where package_id = :package_id select p.parameter_id, p.parameter_name, coalesce(p.description, 'No Description') as description, coalesce(v.attr_value, 'No Value') as attr_value, coalesce(p.section_name, 'No Section Name') as section_name from apm_parameters p left outer join (select parameter_id, attr_value from apm_parameter_values v where v.package_id = :package_id) v on p.parameter_id = v.parameter_id where p.package_key = (select package_key from apm_packages where package_id = :package_id) $additional_sql