الربط بين ثلاثه جداول

[mido_develper]

عندي 3 جداول هم employees, departments, locations
ويتضمنوا هذه الحقول


desc employees;
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE
JOB_ID
SALARY
COMMISSION_PCT
MANAGER_ID
DEPARTMENT_ID


desc locations;
LOCATION_ID
STREET_ADDRESS
POSTAL_CODE
CITY
STATE_PROVINCE
COUNTRY_ID

desc departments;
DEPARTMENT_ID
DEPARTMENT_NAME
MANAGER_ID
LOCATION_ID



بس مش فاهم الكود الي بيربط بينهم وهو:


select employee_id, city, department_name
from employees e join departments d

on d.department_id = e.department_id
join locations l
on d.location_

id = l.location_id;

[mido_develper]

معلش يا جماعه الكود اتكتب غلط


وتصحيحه هو


select employee_id, city, department_name
from employees e join departments d
on d.department_id = e.department_id
join locations l
on d.location_id = l.location_id;




ولكم جزيل الشكر