Mysql error in mysql -

select s.enrollment_id , s.first_name ,s.last_name,      s.nic, d.description_short, s.fee_pkg, sch.school_id,       p.program_id, se.session_id, s.date_of_birth, s.gender,       dis.description discount, s.final_pkg, s.installment_amount,        ins.installment_plan, s.father_name, s.mobile, s.landline,        s.email, cump.campus_name, city.city_name, s.country_id,        s.province      ums_student s , ums_departments d ,       ums_schools sch, ums_programs p,        ums_sessions se, ums_discount_type dis,         ums_inst_plan ins, ums_campus cump ,         ums_city city         left join ums_departments on  d.id=s.department_id ,          left join ums_schools on  sch.school_id=s.school_id ,         left join ums_programs on p.program_id=s.program_id ,         left join ums_sessions on se.session_id=s.session_id ,         left join ums_discount_type on dis.discount_id=s.discount ,         left join ums_inst_plan on ins.id=s.installment_plan ,         left join ums_campus on cump.id=s.campus_id ,         left join ums_city on city.id=s.city_id; 

i trying query , getting error

error code : 1064 have error in sql syntax; check manual corresponds mysql server version right syntax use near 'join ums_programs on p.program_id=s.program_id ,             left join ums_sessions o' @ line 14 

plz me out.

you don't need - , can't have - and before each left join. remove ands. also, don't need list tables before doing joins. doing so, joining each table twice, once cross join, extremely inefficient.

your sql should this:

select s.enrollment_id , s.first_name ,s.last_name,      s.nic, d.description_short, s.fee_pkg, sch.school_id,      p.program_id, se.session_id, s.date_of_birth, s.gender,      dis.description discount, s.final_pkg, s.installment_amount,       ins.installment_plan, s.father_name, s.mobile, s.landline,       s.email, cump.campus_name, city.city_name, s.country_id,        s.province  ums_student s      left join ums_departments d on  d.id=s.department_id      left join ums_schools sch on  sch.school_id=s.school_id      left join ums_programs p on p.program_id=s.program_id      left join ums_sessions se on se.session_id=s.session_id      left join ums_discount_type dis on dis.discount_id=s.discount      left join ums_inst_plan ins on ins.id=s.installment_plan      left join ums_campus cump on cump.id=s.campus_id      left join ums_city city on city.id=s.city_id;