Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Query designer relating tables
Why can't I make a query ivolving four tables
I've got four tables:
volunt, year, adress and function
The volunt table refers to the three other tables
So the volunt table is the one that connect the others,
and gathers information about a volunteer.
I encountered no problems doing relating these four tables in the database designer.
When I try to create a query on these tables involving all four tables I get
an error like "SQL; collumn 'pk_volunt' is not found" (the 'pk_volunt'
portion of the message is different depending on the the fourth table)
When I remove one table (not the volunt) from the query I can successfully save it.
the sql looked like this:
SELECT volunt.pk_volunt, year.*, Function.name;
FROM roster!year INNER JOIN roster!volunt;
INNER JOIN roster!function;
INNER JOIN roster!adres ;
ON Adress.pk_adress = volunt.pk_volunt ;
ON Function.pk_functie = volunt.pk_function ;
ON year.pk_year = volunt.pk_year
Tia.
Victor
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