peshopbs2

Untitled

Dec 1st, 2019
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT
  2. e.employee_id, e.first_name, e.last_name
  3. FROM employees AS e
  4. LEFT JOIN employees_projects AS ep
  5. ON ep.employee_id = e.employee_id
  6. WHERE ep.employee_id IS NULL
  7. ORDER BY first_name ASC, last_name ASC
  8. LIMIT 3;
Advertisement
Add Comment
Please, Sign In to add comment