1054 - Unknown column 'b1.remarks' in 'field list'

select a1.gender_type, a1.your_name, a1.comp_name, a1.web_address, a1.phone, a1.phone1, a1.mobile, a1.fax, a1.year_estd, a1.comp_type, a1.noof_emp, a1.category, a1.comp_profile, a1.comp_logo, a1.job_posting_type, b1.job_title, b1.mailing_username, b1.job_contact_person, b1.job_contact_no, b1.job_contact_address, b1.contact_type, b1.category_tbl_slno, b1.key_skills, b1.no_of_vacancy, b1.min_salary, b1.max_salary, b1.hideSalary, b1.gender_pref, b1.min_exp, b1.max_exp, b1.vacancy_type, b1.vacancy_detail, b1.recv_date, b1.remarks, b1.job_country, b1.job_state, b1.job_city, b1.job_address, b1.sub_category_tbl_slno, b1.payment_basis, b1.apply_job_posting_type, b1.qualification, b1.active_status, b1.active_date,b1.file_name,b1.slno from members_recruiter as a1, job_posting as b1 where b1.slno='476937' and a1.mem_slno='551295' and b1.active_status!='D' and a1.mem_slno=b1.mem_slno

[TEP STOP]