Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. +-----------+-------------------+-------------------+-----------------+
  2. | team_name | user_one | user_two | team_note |
  3. +-----------+-------------------+-------------------+-----------------+
  4. | Team one | skuhsa@jdds.dfd | kgihse@kdhf.dfj | one to twenty |
  5. | Team two | dsjgknsz@djfd.fkg | | three to thirty |
  6. +-----------+-------------------+-------------------+-----------------+
  7.  
  8. +-------------------+-----------+-----------------+
  9. | email | user_name | user_note |
  10. +-------------------+-----------+-----------------+
  11. | skuhsa@jdds.dfd | skuhsaone | gimme money |
  12. | kgihse@kdhf.dfj | kgihse | drop it |
  13. | dsjgknsz@djfd.fkg | dsjgknsz | just eat it |
  14. +-------------------+-----------+-----------------+
  15.  
  16. +-----------+--------------------+-----------+------------------+-----------+-----------------+
  17. | team_name | user_one | user_name | user_two | user_name | team_note |
  18. +-----------+--------------------+-----------+------------------+-----------+-----------------+
  19. | Team one | skuhsa@jdds.dfd | skuhsaone | kgihse@kdhf.dfj | kgihse | one to twenty |
  20. +-----------+--------------------+-----------+------------------+-----------+-----------------+
  21. | Team two | dsjgknsz@djfd.fkg | dsjgknsz | | | three to thirty |
  22. +-----------+--------------------+-----------+------------------+-----------+-----------------+
  23.  
  24. SELECT * FROM [Team]
  25. LEFT JOIN [User]
  26.  
  27. SELECT team_name, user_one, u1.user_name, user_two, u2.user_name, team_note
  28. FROM team t
  29. LEFT JOIN user u1 ON t.user_one = u1.email
  30. LEFT JOIN user u2 ON t.user_one = u2.email
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement