SQL - Request from a movie database to get all the movies and their details
===

I found similar questions but quite different in the end, and none answers my problem.

I use mySQL

I have a table movie_artist_role liking 3 tables movie, artists and role containing the 3 keys

    mo_id
    ar_id
    ro_id.

The table movie contains

    mo_id
    mo_title

the table artists contains

    ar_id
    ar_name

the table role contains

    ro_id
    ro_name (actor or producer for instance)

I want to display the list of the films, and for each films the actors and the director(s)

What is the most efficient way to get that? Is it possible in one unique query with multiple left join?

Thanks
