Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +-----------+-------------------+-------------------+-----------------+
- | team_name | user_one | user_two | team_note |
- +-----------+-------------------+-------------------+-----------------+
- | Team one | skuhsa@jdds.dfd | kgihse@kdhf.dfj | one to twenty |
- | Team two | dsjgknsz@djfd.fkg | | three to thirty |
- +-----------+-------------------+-------------------+-----------------+
- +-------------------+-----------+-----------------+
- | email | user_name | user_note |
- +-------------------+-----------+-----------------+
- | skuhsa@jdds.dfd | skuhsaone | gimme money |
- | kgihse@kdhf.dfj | kgihse | drop it |
- | dsjgknsz@djfd.fkg | dsjgknsz | just eat it |
- +-------------------+-----------+-----------------+
- +-----------+--------------------+-----------+------------------+-----------+-----------------+
- | team_name | user_one | user_name | user_two | user_name | team_note |
- +-----------+--------------------+-----------+------------------+-----------+-----------------+
- | Team one | skuhsa@jdds.dfd | skuhsaone | kgihse@kdhf.dfj | kgihse | one to twenty |
- +-----------+--------------------+-----------+------------------+-----------+-----------------+
- | Team two | dsjgknsz@djfd.fkg | dsjgknsz | | | three to thirty |
- +-----------+--------------------+-----------+------------------+-----------+-----------------+
- SELECT * FROM [Team]
- LEFT JOIN [User]
- SELECT team_name, user_one, u1.user_name, user_two, u2.user_name, team_note
- FROM team t
- LEFT JOIN user u1 ON t.user_one = u1.email
- LEFT JOIN user u2 ON t.user_one = u2.email
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement