Join query leads to error?

[Krtoffel]

PHP Code:

    $maak_tabel = mysql_query
    ("SELECT F.naam, F.jaar, F.genre_id, G.naam AS genre
    FROM film F
    JOIN genre G
    ON F.genre_id = G.id"); 


Could anyone explain to me why this leads to an error? It works in phpmyadmin and it also works when I change "F.naam" into "naam". What am I missing here?

Thanks in advance!

[Old Pedant]

What is the error?

Find out by using mysql_error(), possibly in or die( mysql_error() )