Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.employee_id, e.first_name,
- CASE
- WHEN p.start_date >= '2005-01-01' THEN
- CONCAT(e.first_name, '\'s project: ', p.name)
- ELSE
- p.name
- END AS project_name,
- p.start_date
- FROM employees AS e
- INNER JOIN employees_projects AS ep
- ON ep.employee_id = e.employee_id
- INNER JOIN projects AS p
- ON p.project_id = ep.project_id
- WHERE e.employee_id = 24
- ORDER BY project_name ASC
Advertisement
Add Comment
Please, Sign In to add comment