Mysql join between three tables query


I'm new to Mysql, just started today. I have to use the syntax shown here to add values, so I want to get the director name from the movie with id 289

INSERT INTO `db`.`movies` (`id`, `name`) 
VALUES (289,"The movie title");

INSERT INTO `db`.`ddirectos` (`directorsid`, `moviesid`) 
VALUES (1,289);

INSERT INTO `db`.`directors` (`id`, `name`,`last`) 
VALUES (1,"roxy","roxylast");

Best Answer

    FROM directors dir
    INNER JOIN ddirectos ddir ON = ddir.directorsid
    INNER JOIN movies mov ON = ddir.moviesid 
    WHERE = 289

I believe this is what you are looking for.