Sorting in a relational database

[BFH]

I have a database ("all years") related to three others; one is for 2002

[Ender]

Your current structure makes a combined report impossible.

If aggegating multiple years is a common need, then it would be better to have all names combined in one table. An additional table (of enrollments or whatever,) could be used if each name could have more than one year's data associated with it.

If this type of report is not frequently needed, then maybe just import all years into a temp table so you can generate the report.