Prorate Conventions SQL Query

select
ct.prorate_convention_code,
ct.description prorate_convention_description,
ct.fiscal_year_name,
ct.depr_when_acquired_flag,
c.start_date,
c.end_date,
c.prorate_date

from
fa_convention_types ct,
fa_conventions c

where
ct.prorate_convention_code=c.prorate_convention_code