I Have thre table FILM (Movies), MAGAZZINO (Store), GENERI (Kind of movies),
In the table FIELDS there are 2 fields joined with the table GENERI, Genere and Gener2

This SQL gives me an error (column gener2 not found) though I can preview it.
The error is generated only when I try to save the query and sometimes (not always) when I run it.

SELECT Film.titolo, Generi.descriz, Generi_a.descriz,;
count( Magazzino.codice), Film.codice;
FROM video!magazzino INNER JOIN video!film;
INNER JOIN video!generi;
INNER JOIN video!generi Generi_a ;
ON Film.gener2 = Generi_a.codice ;
ON Generi.codice = Film.genere ;
ON Magazzino.codifilm = Film.codice;
GROUP BY Film.codice

Can anyone helps me ?

Hope this example would be clear enough

Thanks

Alessio