mysql> select song.title, artist.artist, genre.genre_name from song left join genre on song.genreid=genre.id left join artist on song.artistid=artist.id where artist.artist like "%sublime%" Order By song.title; +--------------------------------------+---------+---------------------+ | title | artist | genre_name | +--------------------------------------+---------+---------------------+ | 40 Oz. to Freedom | sublime | Ska | | 5446 That's My Number/Ball and Chain | sublime | Ska | | 89 Vision | sublime | Other | | April 29, 1992 (Miami) | sublime | Other | | April 29th 1992 | sublime | Ska | | Badfish | sublime | Ska | | Boss DJ | sublime | Other | | Burritos | sublime | Ska | | Caress Me Down | sublime | Ska | | D.J.s | sublime | Rock/Pop | | Date Rape | sublime | Ska | | Doin' Time | sublime | Ska | | Don't Push | sublime | Reggae | | Drunk Drivin' | sublime | Ska | | Garden Grove | sublime | Ska | | Get Out! | sublime | Ska | | Get Ready | sublime | Ska | | Greatest-hits | sublime | Punk | | Had A Dat | sublime | Ska | | Jailhouse | sublime | Ska | | KRS One | sublime | Other | | Lets Go Get Stoned | sublime | Ska | | Mary | sublime | Rock | | Mary | sublime | Ska | | New Realization | sublime | Other | | New Realization | sublime | Rock | | No Woman No Cry | sublime | Other | | Pawn Shop | sublime | Ska | | Pawn Shop | sublime | Rock | | Right Back | sublime | Ska | | Rivers of Babylon | sublime | General Alternative | | Romeo | sublime | Other | | Same In The End | sublime | Other | | Santeria | sublime | Ska | | Saw Red | sublime | Ska | | Scarlet Begonias | sublime | Ska | | Scarlet Begonias | sublime | Ska | | Slow Ride | sublime | Other | | Smoke Two Joints | sublime | Ska | | Superstar Poonani | sublime | Ska | | The Ballad Of Johnny Butt | sublime | Ska | | Trenchtown Rock | sublime | Rock | | Trenchtown Rock | sublime | Other | | Waiting For My Ruca | sublime | Ska | | What Happened | sublime | Ska | | What Happened | sublime | Ska | | What I Got | sublime | Ska | | What's Really Goin' Wrong | sublime | Ska | | Why Can't we be Friends | sublime | Other | | Wrong Way | sublime | Ska | +--------------------------------------+---------+---------------------+ 50 rows in set (0.00 sec)