CREATE VIEW managementequipment
AS select equipment.eqm_id AS eqm_id , address.add_unit AS add_unit, image.img AS img , source.sou_id AS sou_id , details.srl_id AS srl_id , details.det_store AS det_store , details.det_allo AS det_allo , details.det_con AS det_con , details.det_pice AS det_pice , details.det_cur AS det_cur , member.mem_rank AS mem_rank , member.mem_name AS mem_name , member.mem_last AS mem_last , member.job_title AS job_title , version.ver_name AS ver_name , brand.bnd_name AS bnd_name , category.cat_name AS cat_name , type.typ_name AS typ_name , equipment.eqm_date AS eqm_date
FROM (((`image` join (`source` join (`details` join `equipment` on((`details`.`srl_id` = `equipment`.`srl_id`))) on((`source`.`sou_id` = `equipment`.`sou_id`))) on((`image`.`img` = `equipment`.`img`)))
join `address` on((`equipment`.`add_id` = `address`.`add_id`))
join `member` on((`equipment`.`men_id` = `member`.`mem_id`))
join `category` on((`equipment`.`cat_id` = `category`.`cat_id`))
join `type` on((`category`.`typ_id` = `type`.`typ_id`))
join `version` on((`equipment`.`ver_id` = `version`.`ver_id`))
join `brand` on((`version`.`bnd_id` = `brand`.`bnd_id`)))
WHERE equipment.eqm_id = address.add_id;
ติด ERROR ตรงนี้ครับ #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE equipment.eqm_id = address.add_id' at line 10