accumulated depriciation calculation

Hi ,

I am calculating accumulated depriciation and NBV .I am using the following query .But for each asset there are multiple rows available .I need  one row which i will show in my report.

select (fds.deprn_reserve) accumulated_depriciation,(fb.cost-fds.deprn_reserve)NBVfrom fa_books fb, fa_deprn_summary fdswhere fb.asset_id=fds.asset_idand fb.book_type_code=fds.book_type_codeand fds.ASSET_ID=fb.asset_idand fb.date_ineffective is nulland fb.ASSET_ID=input_assetidHow i will filter the other rows?..probably they are available because multiple time depriciation has run...