peshopbs2

Untitled

Dec 1st, 2019
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT e.employee_id, e.first_name,
  2. CASE
  3. WHEN p.start_date >= '2005-01-01' THEN
  4. CONCAT(e.first_name, '\'s project: ', p.name)
  5. ELSE
  6. p.name
  7. END AS project_name,
  8. p.start_date
  9. FROM employees AS e
  10. INNER JOIN employees_projects AS ep
  11. ON ep.employee_id = e.employee_id
  12. INNER JOIN projects AS p
  13. ON p.project_id = ep.project_id
  14. WHERE e.employee_id = 24
  15. ORDER BY project_name ASC
Advertisement
Add Comment
Please, Sign In to add comment