Back to top
SELECT vacancyID, n_adHeader, n_Town, n_Postcode, n_nurseryname, n_adDetails, n_experienceRequired, n_qualifications, n_aboutDetails, n_startdate, n_closedate, n_Pay, n_payperiod, n_holiday, n_hours, areaID, ExpiryDate, DateApproved FROM dbo.tbl_nursery_vacancies WHERE parent_Display = 1 ORDER BY DateInput