I am so confused. I have a query:
Code:
SELECT Songs.SongID, Songs.Title, Songs.Alternative
FROM Songs
WHERE (((Songs.Alternative)<>"UNIQUE"))
ORDER BY Songs.Title;
I was hoping that where clause would filter out rows where the Alternative field had "UNIQUE", but it also filters out all rows where Alternative has nothing.
Example:
Songs Table:
Code:
SongID Title Alternative
1 hello UNIQUE
2 goodbye DELETE
3 where MASTER
4 how
5 which
Using that query I only get:
Code:
2 goodbye DELETE
3 where MASTER
Why? How should I be doing this so I get all rows except the one that has "UNIQUE" in it?