ช่วยดู Syntax SQL การสร้างตาราง View แบบ Join Table หน่อยคับไม่แน่ใจว่าผิดตรงไหนลองแก้มาพอสมควรไม่ผ่านสักที่

CREATE VIEW managementnotebook
AS select equipment.eqm_id AS eqm_id , set.setname AS set.setname , serial.serialname_id AS serial.serialname , set.emp_id AS set.emp_id , employee.name AS employee.name , employee.rank AS employee.rank , employee.grade AS employee.grade , notebook.dep AS notebook.dep , notebook.rank_now AS notebook.rank_now , notebook.rent_date AS notebook.rent_date , notebook.return_date AS notebook.return_date , type.typename AS type.typename , type.typ_id AS type.typ_id
FROM (((`serial` join (`type` join (`set` join `equipment` on((`set`.`set_id` = `equipment`.`set_id`))) on((`type`.`typ_id` = `equipment`.`typ_id`))) on((`serial`.`srl_id` = `equipment`.`srl_id`))) 
join `employee` on((`set`.`emp_id` = `employee`.`emp_id`))) 
join `notebook` on((`equipment`.`n_id` = `notebook`.`n_id`)))

WHERE type.typename = 'notebook';