Red - Released June 1998 1. The Guns of August 2. A World in Arms 3. Twentieth Century Man 4. The New Revolution 5. Building a New Soviet Man 6. Apocalypse Part I 7. Part II 8. The Eagle and the Bear 9. Soldiers March On 10. Dissident 11. Able Archer 12. After the Nightmare 13. Frost and Tears 14. The Task

select *, DATENAME ( month , A.date_started ) as datestartedMM, DATENAME ( year , A.date_started ) as datestartedYY, DATENAME ( month , A.date_completed ) as datecompletedMM, DATENAME ( year , A.date_completed ) as datecompletedYY from albums a, songs b where a.foldername = 'red' and b.albumid = a.albumid order by b.tracknumber