sqlfriends (5/5/2013)
but how can I get the first record of addressID? I got duplicates.
Can you define "first record"?
And what do those duplicates mean - same pupil lives in multiple addresses at the same time?
_____________
Code for TallyGenerator