UNHCE Information Technology & Distance Education Blog

MarTech has shared a SQL which will allow you to create a mailing list of kids from the activity file.

Click here for further information:

This SQL will create a mailing list of kids from the activity file. It is pulling members enrolled in a Creative Arts activity by the ES-237 code. You can modify this by selecting a different code in the line:

And Activity.ES237 <= "BCD"

This works in the State Database when not all counties are using a unified Activity Code file.

Select Distinct Youth.firstname, Youth.lastname, Youth.address, Youth.city, Youth.state, Youth.zip
From "Youth2a.db" Youth
Inner Join "Youth2h.db" YouthAct
On (Youth.MemberID = YouthAct.MemberID)
Inner Join "Youth2g.db" Activity
On (YouthAct.ActivityID = Activity.ActivityID)
Where Activity.ES237 >= "B"
And Activity.ES237 <= "BCD"
And Youth.Age >= "12"
And Youth.Category = "M"
And Youth.Status = 'R'
Order by Youth.Lastname, Youth.firstname

For further information on this SQL or the use of Blue Ribbon Software, contact MarTech.