Ok I have three tables with the following fields (basically):
ARTISTS
***********
artist_id (primary key)
artist_name
ALBUMS
***********
album_id (primary key)
album_title
album_description
ARTISTALBUMS (join table)
************
artistalbum_artist_id (primary key)
artistalbum_album_id (primary key)
I need a query to join the tables that will display all the albums in ASC order by artist_name. The problem is there can be multiple ARTISTS for each ALBUM. So what is the SQL for the select?
ARTISTS
***********
artist_id (primary key)
artist_name
ALBUMS
***********
album_id (primary key)
album_title
album_description
ARTISTALBUMS (join table)
************
artistalbum_artist_id (primary key)
artistalbum_album_id (primary key)
I need a query to join the tables that will display all the albums in ASC order by artist_name. The problem is there can be multiple ARTISTS for each ALBUM. So what is the SQL for the select?