[Koha] Need SQL query help, please
carol.kresge at gmail.com
Wed Apr 4 15:12:15 NZST 2012
They only go to one school each. another possibility is they do have more
than 1 item checked out
On Wed, Apr 4, 2012 at 9:58 AM, Chris Cormack <chris at bigballofwax.co.nz>wrote:
> 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?
supporting Lao youth in their quest for a brighter future....
The Language Project…an American 501(c)3 charity
Lao address: PO Box 905, Luang Prabang, Laos
Lao mobile: 856 20 97122771
US address: PO Box 13201, Tallahassee, FL 32317
More information about the Koha