LIST STU IDN ADS DSP CSE STU.NM STU.ID STU.GR DSP.DY DSP.DD STU.ETH? (( LEFT(RC1,1) )) ADS.CD? STU.LF STU.LF? ADS.CD? CSE.DI CSE.ED CSE.XD BY STU.SC IF ( DSP.DS : SUS OR DSP.DS : SUSPX OR DSP.DS : EXP OR DSP.DS : OCS OR DSP.DS : CSUS )
This query will list all students that have been suspended.
Add this if you want all students.
AND ( CSE.ED ; " " AND CSE.XD = NULL )