SELECT sectorID, sectorName FROM tblIndustrySectors ORDER BY sectorName SELECT jobTypeID, jobTypeName FROM tblJobTypes SELECT areaID, areaName FROM tblJobAreas ORDER BY areaName ASC
or