Re: query problem with multiple tables

In article <2eb37o$7eo@darkstar.UCSC.EDU> ericd@cats.ucsc.edu (Eric D Davis) writes: [...] >So I setup my ace report as follows: > BEFORE GROUP OF pupil.name > PRINT pupil.name [...] >Here's the problem we have: > What if I have two students with the exact same name? >The BEFORE/AFTER GROUP will not differentiate between the >two identical names - the BEFORE will print the information >from the first record and the AFTER will print the information >from the last! [...] You've got a pupil ID, so use it. Say, "ORDER BY pupil.name, pupil.id, class.name". BEFORE ... becomes "BEFORE GROUP OF pupil.id". You still order by pupil name, but two students with the same name appear as two students, because their IDs are different. Is this satisfactory? -- ========================================================================== That which is necessary is never evil. If an evil seems necessary, look to your context; that's where its root lies.