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