SELECT m.MFR_ID, m.MFR_NAME, m.MfrCompanyLogo, m.MFR_EXTERNAL_URL, m.MfrProductTextBite, m.BUILDING_ADDRESS, m.BUILDING_ADDRESS2, m.CITY, m.STATE, m.ZIP_CODE, m.MAIN_AREA_CODE, m.MAIN_PHONE, m.ProfilePageOverviewTextP1, img.Image AS mfrLogo FROM tblManufacturers m, qrySecureImageFullPathLookup qryImageFullPathLookup img WHERE m.MfrCompanyLogo = img.ImageID AND m.MFR_ID =