Advertisement
Guest User

Untitled

a guest
Apr 18th, 2015
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. courses.uuid, units.uuid FROM units LEFT JOIN courses ON units.course_uuid = courses.uuid AND units.position > 2;
  2.  
  3. uuid | uuid
  4. -------------+-----------
  5. ruby-basics | RUBY-007
  6. ruby-basics | RUBY-006
  7. ruby-basics | RUBY-005
  8. ruby-basics | RUBY-END
  9. ruby-basics | RUBY-004
  10. ruby-basics | RUBY-003
  11. ruby-basics | RUBY-002
  12. ruby-basics | RUBY-001c
  13. | RUBY-001b
  14. | RUBY-001a
  15. | RUBY-000
  16. (11 rows)
  17.  
  18.  
  19.  
  20. SELECT courses.uuid, units.uuid FROM units LEFT JOIN courses ON units.course_uuid = courses.uuid WHERE units.position > 2;
  21.  
  22. uuid | uuid
  23. -------------+-----------
  24. ruby-basics | RUBY-007
  25. ruby-basics | RUBY-006
  26. ruby-basics | RUBY-005
  27. ruby-basics | RUBY-END
  28. ruby-basics | RUBY-004
  29. ruby-basics | RUBY-003
  30. ruby-basics | RUBY-002
  31. ruby-basics | RUBY-001c
  32. (8 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement