Job Post Details

SELECT a.*,b.* FROM tbl_jobvacancy a, tbl_jobvacancydetail b WHERE a.urgent_job=1 AND a.id=b.vacancy_id AND a.id=69 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

Job Post Details

Jobs

KR MARINE SERVICES

Post ID: CF/256-69

Requirement for

Rank	Chief Cook
Experience	12 - 18 Month
Type of Ship	Bulk Carrier
No of Vacancy	1
Expected Joining Date	30-01-2021
Job Expiry Date	23-12-2020 - 23-01-2021

Job Description

Experience Candidate preffered.