select d.REG_ID,r.REGION_NAME,d.DISTRICT_NAME, d.DIS_ID
from SCOTTISH_DISTRICTS d,SCOTTISH_REGIONS r
where d.REG_ID = 10
and d.REG_ID = r.REG_ID
order by 1