Database query failed Unknown column 'jobtype.var_name' in 'where clause'
Last Query run : SELECT job.id as job_id, job.var_name as job_var_name, job.job_title, job.job_description, job.city, job.fk_employer_id as employer_id, employer.company_name,employer.var_name as company_var_name, job.job_salary, job.salaryfreq, job.created_at FROM jl_job AS job, jl_employer AS employer WHERE job.is_active = 'Y' AND job.id > 0 AND job.job_status = 'approved' AND ( jobtype.var_name ='full-time' OR jobtype.id = 'full-time' ) GROUP BY job.id ORDER BY created_at DESC