SELECT MFR_ID, MFR_NAME FROM tblManufacturers WHERE MFR_ID IN () ORDER BY MFR_NAME SELECT distinct categoryId AS subCatId, categoryDesc AS subCat FROM qmd_getSearchResults ORDER BY categoryDesc SELECT distinct categoryId AS subCatId, categoryDesc AS subCat FROM qmd_getSearchResults ORDER BY categoryDesc ---> --->