select COUNT(*) AS totalJobs FROM mtJobDetail INNER JOIN mtGeneralLocation ON mtJobDetail.jobLocId = mtGeneralLocation.locId inner join mtJobType on mtJobType.typeID=mtJobDetail.jobTypeId INNER JOIN mtJobSalaryBand ON mtJobDetail.jobSalryId = mtJobSalaryBand.salId INNER JOIN mtJobCategory ON mtJobDetail.jobCatId = mtJobCategory.catId INNER JOIN mtJobSchoolType ON mtJobDetail.jobSchoolId = mtJobSchoolType.schoolTypeId WHERE mtJobDetail.JobID <> 19409 AND mtJobDetail.jobCatId = AND jobEndDate>=getDate() and jobDisableStatus=0 Incorrect syntax near the keyword 'AND'. Database access error. Please contact web administrator with error code: 10092010233959348765409 | ||||||||||||||||||||||||

