In this query, I want the results sorted alphabetically on the text field LPs.Album. But instead I'm getting the list in a seemingly random order. What am I doing wrong?
Query:
Code:
SELECT LPs.LPID, LPs.Album, Artists.OriginalName, LPs.Performer_id, LPs.[KeyArtistRole]
FROM Artists INNER JOIN LPs ON Artists.ArtistID = LPs.Performer_id
ORDER BY LPs.Album;
Results:
LPID |
Album |
OriginalName |
Performer_id |
KeyArtistRole |
1 |
1,2,3 Red Light |
1910 Fruitgum Company |
3 |
1 |
2 |
Greatest Hits |
Abba |
4 |
1 |
3 |
The Lexicon of Love (c) |
ABC |
5 |
1 |
4 |
Toys in the Attic |
Aerosmith |
6 |
1 |
5 |
Eye of the Hurricane |
Alarm; The |
8 |
1 |
6 |
Local Color |
Allison; Mose |
9 |
1 |
7 |
America |
America |
10 |
1 |
8 |
Best of; The |
Andrew Sisters |
11 |
1 |
9 |
Animalism |
Animals; The - Eric Burdon and |
13 |
1 |
10 |
Greatest Hits |
Animals; The - Eric Burdon and |
13 |
1 |