SQL Query about Project and Asset

Hi All,

I would like to use SQL to query the project , invoice and asset data. when I use the following SQL, the data duplicated.

It should be 2 rows.

May I know what link I missed?

SELECT fa.asset_number           fin_asset_number,
       fad.description           fin_asset_name,
       pa.segment1               project_number,
       t.task_number,
       paa.asset_name            project_asset_name,
       pal.project_asset_line_id project_asset_line_number,
       pei.expenditure_item_id   cost_transanction_number,
       aia.invoice_num
FROM   fa_additions_b fa,
       fa_asset_invoices ai,
       pjf_projects_all_b pa,
       pjf_tasks_v t,
       pjc_prj_asset_lns_all pal,