Advertisement
Guest User

City

a guest
Mar 19th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 KB | None | 0 0
  1. select L.city, R.region_name
  2.  
  3. from employees E, regions R, departments D, locations L, countries C
  4.  
  5. where R.region_ID = C.region_ID and C.country_ID = L.country_ID and L.location_ID = D.location_ID and D.department_ID = E.department_ID and E.first_name = 'Lex'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement