Skip to content

Instantly share code, notes, and snippets.

@JonesCharly

JonesCharly/jointure.sql

Last active June 24, 2019 08:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JonesCharly/213acafef86a6c68c169857f00131a3f to your computer and use it in GitHub Desktop.
Save JonesCharly/213acafef86a6c68c169857f00131a3f to your computer and use it in GitHub Desktop.
Download ZIP
bdd jointure
Raw
jointure.sql
select lastname, firstname, role, name
from wizard
inner join player inner join team
ORDER BY name, role, lastname, firstname;
select lastname, firstname, role
from wizard
inner join player WHERE role ='seeker'
ORDER BY lastname, firstname ;
select lastname, firstname, role
from wizard
inner join player WHERE role IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment