Asset Books SQL Query

select
fb.book_type_code,
fb.asset_id,
fa.asset_number,
fa.description,
fb.date_placed_in_service,
fb.date_effective,
fb.deprn_start_date,
fb.deprn_method_code,
fb.adjusted_cost,
fb.cost,
fb.original_cost,
fb.salvage_value,
fb.prorate_convention_code,
fb.prorate_date,
fb.capitalize_flag,
fb.depreciate_flag,
fb.date_ineffective,
fb.basic_rate,
fb.adjusted_rate,
fb.recoverable_cost,
fb.unrevalued_cost,
fb.adjusted_recoverable_cost

from
fa_books fb,
fa_additions fa

where
fb.asset_id=fa.asset_id (+)