[Koha] Need SQL query help, please

[Chris Cormack]

On 4 April 2012 14:53, Carol Kresge <carol.kresge at gmail.com> wrote:
> Thanks, but I get an error with both and it won't run
> error: 1242 subquery returns more than 1 row
>
> Maybe that is because I should have mentioned that the User attribute
> "school" goes to an authorised value category and has a lot of different
> values (they go to many different schools...Phongkham, Pasatipatai,
> Phasabandith...) Sorry,
> do you have another idea?

Ah my bad,

The do only go to one school each though right? Or can one student be
at more than one?

Chris