Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH
- i AS (SELECT id,
- first_name,
- last_name
- FROM people),
- k AS(SELECT person_id,
- instituition
- FROM education)
- SELECT i.first_name,
- i.last_name,
- k.instituition
- FROM i LEFT OUTER JOIN k ON i.id = k.person_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement