Suppose we have three tables

Employee(Emp_code,Name,Dept_Code,Desig_Code,CityID)

Department(Dept_Code,Dept_Name)

Designation(Desig_Code,DesigName)

City(CityID,CityName)

Query :

Select Emp_code,Name,Dept_Name,DesigName,CityName from Employee inner join Department On Department.Dept_Code=Employee.Dept_Code inner join

Designation ON Designation.Desig_Code=Employee.Desig_Code inner join City ON City.CityID=Employee.CityID

Same for other table