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='14' order by com_vacancy.ClosingDate desc