Skip to content

Instantly share code, notes, and snippets.

@toyeiei

toyeiei/.sql

Created Nov 8, 2018
Embed
What would you like to do?
SQL for Beginner - JOIN more than two tables
-- JOIN more than two tables
SELECT
artists.name,
albums.title,
tracks.name
FROM artists
JOIN albums
ON artists.artistid = albums.artistid
JOIN tracks
ON tracks.albumid = albums.albumid
WHERE artists.name = 'Aerosmith';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.