A request for a query to retrieve specific information about students and their associated teachers and contacts.

Environment

•    Flex System

Resolution

To fulfill the request, the following query was created. This query focuses on retrieving information for students and their primary contacts (Order Number 1), including the relationship description for the contact.

Query

LIST STU SEC MST SSE STF CON STU.ID STU.NM STU.GR STF.LN STF.FN STF.ID STF.EM CON.LN CON.FN CON.EM CON.OR CON.RL WHERE CON.OR = 1

Fields Retrieved

Student Information:

•    Student Name (STU.NM)

•    Student Grade (STU.GR)

•    Student ID (STU.ID)

Teacher Information:

•    Teacher Last Name (STF.LN)

•    Teacher First Name (STF.FN)

•    Teacher Staff ID (STF.ID)

•    Teacher Email (STF.EM)

Contact Information (for Parent/Guardian):

•    Contact Last Name (CON.LN)

•    Contact First Name (CON.FN)

•    Contact Email (CON.EM)

•    Contact Order (CON.OR)

•    Contact Relationship (CON.RL)

Additional Notes

•    The query specifically filters contacts to include only those with an Order Number of 1.

•    The inclusion of the Contact Relationship (CON.RL) description is intended to provide additional context.