SELECT tblCredOnline.companyID, tblCredOnline.companyName, tblCredOnline.summary, tblCredOnline.body, tblCredOnline.companyIsActive, tblCredOnline.userID, tblCredOnline.areaID, tblCredOnline.contactName, tblCredOnline.telephone, tblCredOnline.email, tblCredOnline.fax, tblCredOnline.address, tblCredOnline.URL, tblCredOnline.location, tblCredOnline.dateAdded, tblInterestAreas.areaName, tblCredOnline.areaID, B.rank, qryImages.directory, qryImages.filename
FROM tblCredOnline LEFT JOIN tblInterestAreas ON tblCredOnline.areaID = tblInterestAreas.areaID INNER JOIN ContainsTable(tblCredOnline, *, '#form.criteria2#') AS B ON B.[KEY] = tblCredOnline.companyID LEFT JOIN qryImages ON tblCredOnline.logoID = qryImages.imageID
WHERE tblCredOnline.companyIsActive = 1
AND tblCredOnline.areaID =
ORDER BY tblInterestAreas.areaName ASC, tblCredOnline.companyName ASC
SELECT * FROM Companies ORDER BY rank DESC