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=93 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

Urgent Jobs

KR MARINE SERVICES

Post ID: CF/256-93

Urgent Requirement for

Rank	AB
Experience	12 - 18 Month
Type of Ship	Bulk Carrier
No of Vacancy	2
Expected Joining Date	01-03-2021
Job Expiry Date	05-02-2021 - 28-02-2021

Job Description

Well Experienced Candidates,with Indian/UK/Singapore/ Newzealand CoC Prefeered.