Ya basit birsey ama kafam karisti simdi

Select Employee.Firstname,Employee.Surname,Department.Dep tName FROM Department INNER JOIN Employee ON Employee.DeptNo = Department.DeptNo;

Burda sorun yok simdi bu ust koda ek olarak Employee deki EmpNo ile yeni telephone tableindaki EmpNo ayni deger ordan da telephone.Extension i almak istiyorum. Karisik durumda olan kod

Select Employee.Firstname,Employee.Surname,Department.Dep tName,Telephone.Extension FROM Department INNER JOIN (Telephone INNER JOIN Employee ON Telephone.EmpNo = Employee.EmpNo) Employee ON Department.DeptNo = Employee.DeptNo ;

karisik mi anlattim ne :S