mysql - MySQL语法错误(联接表)

谁能告诉我这种语法是什么错误？？？

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

最佳答案

... AS Vessel, FROM ...

在FROM之前，您不应该使用逗号。