1146 - Table 'pinew.job_desc_content' doesn't exist

select b1.applicant,b1.job_posting_status,b1.job_designation,b1.catg_id,a1.mem_slno, a1.city as mem_city, a1.image_cutting_status,b1.ref_web_pdf,b1.data_posting_type,a1.recr_file_name,a1.master_id,a1.gender_type, a1.your_name, a1.comp_name, a1.web_address, a1.mobile, a1.year_estd, a1.comp_type, a1.noof_emp, a1.category, a1.comp_profile, a1.comp_logo, a1.company_logo_size, a1.image_cutting_status, a1.job_posting_type, a1.master_id, b1.job_title, b1.dynamic_job_title, b1.mailing_username, b1.category_tbl_slno, b1.key_skills, b1.no_of_vacancy,b1.currency_type,b1.int_min_salary, b1.int_max_salary,b1.min_salary,b1.max_salary,b1.hideSalary, b1.gender_pref, b1.min_exp, b1.max_exp, b1.vacancy_detail, b1.recv_date, b1.active_date, b1.job_country, b1.qualification, b1.active_status, b1.slno,b1.industry_type,b1.srch_keyword_exact,b1.exp_date,b1.total_seeker_views,b1.working_location_type,a1.mem_oth_status,b1.admin_job_title,b1.interview_type,b1.job_contact_address,b1.walk_in_timing,vacancy_type,night_shift, b1.qual_specification_json, c1.ai_desc from members_recruiter as a1 INNER JOIN job_posting as b1 ON a1.mem_slno=b1.mem_slno LEFT JOIN job_desc_content AS c1 ON c1.job_slno = b1.slno AND c1.ai_status = 'Y' where b1.slno='1210680' and a1.mem_slno='1204883'

[TEP STOP]