error: select *,jobs.i_job_id,jobs.i_save, jobs.c_job_title, jobs.c_company_name,
jobs.c_company_desc,jobs.c_job_desc,jobs.d_created_date,
jobs.c_company_address,jobs.c_tel,jobs.c_fax,jobs.c_email as c_email_jobs,
jobs.d_created_date, job_industry.c_name as industry, job_occupation.c_name as occupation,
job_experience.c_name as experience,job_type.c_name as type,member.c_username,member.i_member_id,
(select if(count(i_job_id)>0,'Y','N') from job_sube where job_sube.i_job_id=jobs.i_job_id and job_sube.i_member_id='') as sube,
(select c_name from job_location where job_location.i_job_location_id=jobs.i_location_id) as c_location_name
from jobs, job_industry, job_occupation, job_experience, job_type, member, employer
where jobs.i_job_id =  
and job_industry.i_job_industry_id=jobs.i_industry_id 
and job_occupation.i_job_occupation_id=jobs.i_occupation_id 
and job_experience.i_job_experience_id=jobs.i_experience_id
and job_type.i_job_type_id=jobs.i_jobtype_id
and member.i_member_id=jobs.i_employer_id 
and employer.i_employer_id=jobs.i_employer_id 
and jobs.c_status = 'Y'