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)