Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. Entities
  2. ------------
  3. Entity | Id | Type
  4. -------------------
  5. Event | 1 | Request
  6. Stroll | 2 | Activity
  7. Dinner | 3 | Activity
  8. Angela | 4 | Person
  9. Anders | 5 | Person
  10. Michael | 6 | Person
  11.  
  12. Junctions
  13. ----------------
  14. Left | Right
  15. ----------------
  16. 1 | 2 // Connect Request -> Stroll
  17. 2 | 4 // Connect Stroll -> Angela
  18. 1 | 3 // Connect Request -> Dinner
  19. 3 | 5 // Connect Dinner -> Anders
  20. 3 | 6 // Connect Dinner -> Michael
  21.  
  22. Request | Activity | Person
  23. -----------------------------
  24. Event | Stroll | Angela
  25. | Dinner | Anders
  26. | Michael
  27.  
  28. Person | Request
  29. -----------------
  30. Angela | Event
  31. Anders | Event
  32. Michael | Event
  33.  
  34. SELECT e1.Entity Request,
  35. e2.Entity Activity,
  36. e3.Entity Person
  37. FROM Junctions j1
  38. JOIN Junctions j2
  39. ON j1.`Right` = j2.`Left`
  40. JOIN Entities e1
  41. ON j1.`Left` = e1.Id
  42. JOIN Entities e2
  43. ON j1.`Right` = e2.Id
  44. JOIN Entities e3
  45. ON j2.`Right` = e3.Id;
  46.  
  47. SELECT j1.`Left` Request,
  48. j1.`Right` Activity,
  49. j2.`Right` Person
  50. FROM Junctions j1
  51. JOIN Junctions j2
  52. ON j1.`Right` = j2.`Left`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement