Aeries related tables are joined through common fields and some tables are joined to a number of different tables. On the left side the TN field in TCH links to the CU field in STU as one-to-many. So every record in TCH may have multiple records in STU, since multiple students can be assigned to one teacher.
Using Multiple Tables
Queries using multiple tables require that all fields selected be qualified with the table name in front of the field, e.g., STU.SN, TCH.TE, etc. The Special Education module utilizes various tables to store data involving Services, Discipline, and Alternate Assessment with the CSE table linking these tables with the STU table.
Related Tables in Aeries
Aeries Query displays related tables in the Tables column. The list of tables will change each time a table is chosen to reflect those tables related to the last table chosen. The following are examples of table combinations frequently used in Aeries Query that are related to the STU table:
STU ATT ABS (Attendance and Absence Codes)
STU ATN (Attendance Notes)
STU SUP (Student Supplemental Info)
STU SSD (Secondary Student Data)
STU RAL (Record Access Log)
STU RJN (Rejoinders)
STU AUT (Authorizations/Prohibitions)
STU ACT (Activities)
STU PGM (Programs)
STU MED (Medical)
STU MHS (Med History)
STU IMM (Immunization)
STU DNT (Dental)
STU ADS (Assertive Discipline)
STU DSP (Dispostions)
STU DIS (Discipline)
STU EXP (Expulsions)
STU CON (Contacts)
STU TST CTL (Test and Testing Control)
STU TST CST (Test and Content Standards)
STU CTS (College Test Scores)
STU FEE (Fees)
STU CNF (Counseling)
STU VIS (Visitations)
STU CSE (Special Ed)
STU CSE CSS (Special Ed Suspensions)
STU CSE CSV (Special Ed Services)
STU LAC (LF info-SABE)
STU LAC LAF (FLOSEM)
STU LAC LAS (Assessment)
STU INV (Interventions)
Veteran query users often type in the tables they will use. However, if the relational order of the tables is violated, the query will not produce any results and the message “Your query does not return any data!” will display.
In an elementary school example below the table order appears as STU TCH DAY ADS while in the second it is STU TCH ADS. The table TCH is not related to the table DAY so the first query will not work. The second query works because TCH relates to ADS through TN so DAY was removed from the query.
In a secondary school example the table order STU MST SEC will not run produce results because the STU table is not directly related to MST.
Once the table order is changed to STU SEC MST the query will run because STU relates to SEC through SN and SEC relates to MST through SE.
REMEMBER that ONLY Related tables can be used in a multiple table query. The order in which we list tables does make a difference.