>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement