Accounting / Auditing, Chemicals
companies.name AS company_name, companies.description As company_descriptioncompanies.logo AS company_logo, companies.website AS company_website, industries.name AS industry_name, role_categories.name AS role_category_name, departments.name AS department_name
FROM jobs
LEFT JOIN companies ON jobs.company_id = companies.id
LEFT JOIN industries ON jobs.industry_id = industries.id
LEFT JOIN role_categories ON jobs.role_category_id = role_categories.id
LEFT JOIN departments ON jobs.department_id = departments.id
WHERE jobs.id = ?
";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $jobId);
$stmt->execute();
$result = $stmt->get_result();
No open positions at the moment.