Valley of Gold - Released November 2001 1. One Hot Night 2. Summer Of Hate 3. Valley Of Gold 4. Cannonball Jones 5. Mark Cheetah 6. There Goes Walt 7. Eric's Gone Crazy 8. The Shut-In's Daughter 9. Crucifixion On Wheels 10. Letter From A Neighbor 11. Sweet Jeremiah

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 = 'valleyofgold' and b.albumid = a.albumid order by b.tracknumber