[Incubus]

اخواني الاعزاء السلام عليكم ورحمه الله وبركاته
عيد سعيد عليكم
واتمنى كل ايامكم تكونو طيبين ان شاء المولى عز وجل

سؤالي هو انني اريد عمل استعلام من اكثر من جدول فيهم lookup tables 
وعملت inner join  ولكن لم تنفع
واليكم هذا المثال

Employee
ID,Name,BirthDate, FK_nationality, FK_City

Company_Employee
,FK_Person_Authority,FK_Employee_ID, National_ID,FK_Status

Nationality
Nationality_Code,Nationality_Description

City
City_Code,City_Description

Authority
Authority_Code,Authority_Description

status
Status_Code,Status_Description


وكما تلاحظون فان الجدولين الرئيسيين هما employee  و  company_employee

اريد عمل استعلام شامل من جمله واحده تقوم بالاستعلام عن الحقول التاليه من كل الجداول
employee.name,employee.birthDate, nationality.nationality_description,city.city.city_description,compny_employee.national_id,authority.authority_description,status.status_description

محاولاتي لعمل الاستعلام:-


select employee.name,employee.birthDate, nationality.nationality_description,city.city.city_description,compny_employee.national_id,authority.authority_description,status.status_description
from company_employee
inner join employee on employee_id = company_employee.fk_employeeid
inner join authority on company_employee.fk_person_authority=authority.authority_description
inner  join status on company_employee.fk_status = status.status_code
inner join nationality on employee.fk_nationality = nationaliy.nationality_code
inner join city on employee.FK_City = city.city_code
where emplyee.ID = 22434

كود :

select employee.name,employee.birthDate, nationality.nationality_description,city.city.city_description,compny_employee.national_id,authority.authority_description,status.status_description
from company_employee
inner join employee on employee_id = company_employee.fk_employeeid
inner join authority on company_employee.fk_person_authority=authority.authority_description
inner  join status on company_employee.fk_status = status.status_code
inner join nationality on employee.fk_nationality = nationaliy.nationality_code
inner join city on employee.FK_City = city.city_code
where emplyee.ID = 22434

فما راي الخبراء

جعل الله ايامكم كلها سعاده ورخاء
وشكرا جزيلا لكم