>>Can anyone tells me the reason why if I try to run a query with more than three table I get the message "Column 'column_name' not found" ?
>>I get the same result even using the Query Wizard.
>>Thanks.
>>Alessio
>It's not related with the number of tables. Rather it actually says that a column cannot be found. Try checking out your column names. Do you refer to a calculated column not existing at the moment ?
>Cetin

No that' s not the problem.

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

Thanks
Alessio