Join tables in MySQL
Join three tables (shows, bands, locations) in MySQL:
select * from shows left join (bands, locations) ON (bands.id = shows.band_id and locations.id = shows.location_id);
For further information see MySQL Reference manual 12.2.7.1. JOIN Syntax.