[Q31]

كود :

SELECT Employee.NAME,
       Employee.BirthDate,
       Nationality.Nationality_Description,
       City.City_Description,
       Company_Employee.National_ID,
       Authority.Authority_Description,
       status.Status_Description
FROM   Authority
       INNER JOIN Company_Employee
               ON Authority.Authority_Code =
                  Company_Employee.FK_Person_Authority
       INNER JOIN Employee
               ON Company_Employee.FK_Employee_ID =
                  Employee.ID
       INNER JOIN City
               ON Employee.FK_City =
                  City.City_Code
       INNER JOIN Nationality
               ON Company_Employee.National_ID =
                  Nationality.Nationality_Code
              AND Employee.FK_nationality =
                  Nationality.Nationality_Code
       INNER JOIN status
               ON Company_Employee.FK_Status =
                  status.Status_Code
WHERE  Employee.ID = 22434