 |
Data Archive
Historical Data
HISTORICAL DATA
SELECT
DataLocations.MarketCode AS MarketCode,
DataLocations.MarketType_ID AS MarketTypeID,
DataLocations.Year AS Year,
DataLocations.Description AS MarketDescription,
DataLocations.ProspectusLocation AS ProspectusLocation,
DataLocations.PriceHistoryDataLocation AS PriceHistoryDataLocation,
DataLocations.FileFormatLocation AS FileFormatLocation,
MarketTypes.Description AS MarketTypeName
FROM DataLocations LEFT JOIN MarketTypes
ON DataLocations.MarketType_ID = MarketTypes.MarketType_ID
WHERE Active IS NULL OR Active <> 'N'
ORDER BY MarketTypes.Description DESC, Year DESC, DataLocations.Description, DataLocations.MarketCode
#MarketTypeName#
|
