Currently, the following sqlite query returns 45 records. I know that only 4 albums exist. How can the query be made to return only those records that are unique to albumTable.album.
Pseudo Code: where albumTable.album is UNIQUE
query = new StringBuilder();
query.append("select albumTable.album, artistTable.artist, songTable.filepath ");
query.append("from albumTable ");
query.append("inner join artistTable ");
query.append("on albumTable.artistID = artistTable.artistID ");
query.append("inner join songTable ");
query.append("on albumTable.albumID = songTable.albumID ");
Thank you.
Aucun commentaire:
Enregistrer un commentaire