oracle
8.1.6
select l.service_level_description, c.default_name as country, round(r.from_value, 2) as from_value, round(r.to_value, 2) as to_value,
r.from_zip_code, r.to_zip_code, round(r.shipping_rate, 2) as shipping_rate
from vbs_rates r, countries c, vbs_service_levels l
where r.country_iso = c.iso(+) and r.shipping_rate_id = :shipping_rate_id
and r.service_level_id = l.service_level_id