Information générale
Catégorie:
Codage, syntaxe et commandes
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
Suivant
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