Query using 2 keys

SBovino

New member
Local time
Today, 11:46
Joined
Feb 29, 2008
Messages
3
I have a database that consists of 7 tables all linked by a school id number. The other tables hold data related to the schools. Another field common to all the related tables is a date field. I could use some direction on how to structure a query that selects data by school and a specific year. The related tables hold data for a number of years and I need to query and report by school for a given year. My main table holds generic school info. The other tables are linked by school_id and have a year field. I have a query that holds all the data - the trick is how to get the data filtered by year. Thanks for getting me started.
 
Have you played with the Query Builder yet? You might be surprised how much can be learned by using the Query Builder and then looking at the SQL view.
 

Users who are viewing this thread

Back
Top Bottom