General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
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