SELECT
    t.TopicID,
    q.ID AS QuantityID,
    t.Description as TopicDescription,
    q.Name as QuantityName,
    dst.Description as DataSourceTopicDescription
FROM
    ApplicationModules.CommonDataModel.Topic t
    JOIN ApplicationModules.DataSourceBus.DataSourceTopic dst ON t.topicID = dst.TopicID
    JOIN ION_Data.dbo.Quantity q ON dst.DataSourceRepresentation = q.name
ORDER BY
    q.ID