I have three dim tables .
1. organissation-- org_id(key)
2.item -- item_P_org_id
3. Customer-- Customer_p_org_id
now I want to join items both org_ids with organization's org id and similarly for customer 's org_ids with organization\s org_id.
how do I do that as I cannot concatenate item_P_org_id and item_S_org_id it has to be seprate columns only.