Question: Why does a Query not work with the STU table?


Answer: When creating a Query, sometimes a connecting table needs to be included. 


Example: LIST INM INM.SC INM.SN INM.DT INM.TY INM.CO INM.ND INM.NM IF INM.TY = M1 


In this example, the INM (Intervention Meetings) needs the table INV (Interventions) to be added to connect STU and INM.

  • The way to test this is to start your query to see the available tables.
  • The only table that connects to INM is INV.

  • Add the INV and now the STU table can be added


Here is the above example with STU and INV added

LIST STU INV INM STU.ID STU.NM STU.GR INV.DT INM.SC INM.SN INM.DT INM.TY INM.CO INM.ND INM.NM