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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only