Need organization inventory data unit cost wise

Content

Dear ,

We have 11 Inventory Organization in which we want inventory unit cost as per org id. 
so we created customized query 
join cst_transactions ct into inv_material_txns imt through ct.INVENTORY_ORG_ID = imt.ORGANIZATION_ID
and select 1 inventory organization but still its shows all organization data.

Thanks