Advertisement
deniswhite77

Untitled

Feb 17th, 2022
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH
  2.  
  3. i AS (SELECT id,
  4.     first_name,
  5.     last_name
  6. FROM people),
  7.  
  8. k AS(SELECT person_id,
  9.     instituition
  10. FROM education)
  11.  
  12. SELECT i.first_name,
  13.     i.last_name,
  14.     k.instituition
  15. FROM i LEFT OUTER JOIN k ON i.id = k.person_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement