26-06-17, 07:39 PM
اخواني الاعزاء السلام عليكم ورحمه الله وبركاته
عيد سعيد عليكم
واتمنى كل ايامكم تكونو طيبين ان شاء المولى عز وجل
سؤالي هو انني اريد عمل استعلام من اكثر من جدول فيهم 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
فما راي الخبراء
جعل الله ايامكم كلها سعاده ورخاء
وشكرا جزيلا لكم
عيد سعيد عليكم
واتمنى كل ايامكم تكونو طيبين ان شاء المولى عز وجل
سؤالي هو انني اريد عمل استعلام من اكثر من جدول فيهم 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فما راي الخبراء
جعل الله ايامكم كلها سعاده ورخاء
وشكرا جزيلا لكم
