SELECT com_vacancy.PosID,com_vacancy.skills, com_company.CompanyName,com_company.CompanyID, com_vacancy.WorkExp, com_vacancy.WorkLocationDetail,
com_vacancy.VacNo,com_vacancy.ClosingDate, com_jobcat.NamaJob, com_jobcat.KdJob
FROM com_vacancy, com_jobcat, com_company
WHERE com_company.CompanyID=com_vacancy.CompanyID AND com_jobcat.KdJob =com_vacancy.KdJob AND com_vacancy.Published='1' AND
com_vacancy.KdJob='31' order by com_vacancy.ClosingDate desc