将MySQL代码转换为Access：GROUP_CONCAT和三重JOIN

将MySQL代码转换为Access：GROUP_CONCAT和三重JOIN

MySQL

GROUP_CONCAt()

函数最常被引用的Access替代方法是Allen Browne

ConcatRelated()

函数，可在此处获得。

至于JOIN周围的括号，是的，Access SQL对此有些挑剔。代替

FROMactor AS aLEFT JOIN film_actor AS fa ON a.actor_id = fa.actor_idLEFT JOIN film_category AS fc ON fa.film_id = fc.film_idLEFT JOIN category AS c ON fc.category_id = c.category_id

尝试

FROM     (        ( actor AS a  LEFT JOIN  film_actor AS fa      ON a.actor_id = fa.actor_id        )         LEFT JOIN         film_category AS fc  ON fa.film_id = fc.film_id    )     LEFT JOIN     category AS c         ON fc.category_id = c.category_id