|
-- Choose a Health region and subregion -- sql=SELECT [HealthRegion_Primary] AS HealthRegion, [HealthSubRegion_Primary] AS Subregion FROM (SELECT DISTINCT HealthRegion_Primary, HealthSubRegion_Primary FROM XRef_MunPoll_Ward_SD_HR_Info WHERE HealthRegion_Primary IS NOT NULL ) UNION SELECT [HealthRegion_Secondary], [HealthSubRegion_Secondary] FROM (SELECT DISTINCT HealthRegion_Secondary, HealthSubRegion_Secondary FROM XRef_MunPoll_Ward_SD_HR_Info WHERE HealthRegion_Secondary IS NOT NULL ) ORDER BY [HealthRegion], [Subregion]
|
|
-- Choisissez une région de la santé et une sous-région -- sql=SELECT [HealthRegion_Primary] AS HealthRegion, [HealthSubRegion_Primary] AS Subregion FROM (SELECT DISTINCT HealthRegion_Primary, HealthSubRegion_Primary FROM XRef_MunPoll_Ward_SD_HR_Info WHERE HealthRegion_Primary IS NOT NULL ) UNION SELECT [HealthRegion_Secondary], [HealthSubRegion_Secondary] FROM (SELECT DISTINCT HealthRegion_Secondary, HealthSubRegion_Secondary FROM XRef_MunPoll_Ward_SD_HR_Info WHERE HealthRegion_Secondary IS NOT NULL ) ORDER BY [HealthRegion], [Subregion]
|