多表查询
select albums.name,albums.year,artists.name from albums,artists;
SELECT * FROM albums JOIN artists ON albums.artist_id = artists.id;
SELECT * FROM albums LEFT JOIN artists ON albums.artist_id=artists.id;
select albums.name as 'Album',albums.year,artists.name as 'Artist' from albums join artists on albums.artist_id = artists.id where album...