MySQL 语法错误(连接表)

Question

谁能告诉我这个语法有什么错误？？？

SELECT crew_no AS Crew_No, concat( last_name, ', ', first_name, ' ', mi ) AS Crew_Name, pos_name AS Position, vesname AS Vessel,
FROM (
(
mastertb
JOIN positiontb ON ( positiontb.pos_code = mastertb.pos_code )
)
JOIN vesseltb ON ( vesseltb.vescode = mastertb.vescode )
)
ORDER BY crew_no
LIMIT 0 , 30

Answer 1

... AS Vessel, FROM ...

FROM 之前不应有逗号。