Hi,

this should be you basic join query(if my spelling is correct):
 
 
SELECT *
FROM Mydata t1, [Cost center mapping] t2, [Cost element mapping] t3, [Country region mapping] t4
WHERE t1.[cost center] = t2.[cost center] and t1.[unique identifier 1] = t3.[CE_SR_NO] and t1.[Company code] = t4.[Company Code]
First check 1 table join, then 2-3
My syntax is different from the classic innner join, but it's more clear for me this way.

Hope this helps you to solve your problem.