SELECT a.*,b.* FROM tbl_jobvacancy a, tbl_jobvacancydetail b WHERE a.urgent_job=1 AND a.id=b.vacancy_id AND a.id=35 AND (a.application_from >= '' and a.application_to >= '' or a.application_to BETWEEN '' and '' or (a.application_from < '' and a.application_to > '')) Job Post Details
Loading...