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@bigballofwax.co.nz>wrote:
On 4 April 2012 14:53, Carol Kresge <carol.kresge@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
-- supporting Lao youth in their quest for a brighter future.... The Language Project…an American 501(c)3 charity Website: www.thelanguageproject.org Gallery: http://laophotographers.zenfolio.com Lao address: PO Box 905, Luang Prabang, Laos Lao mobile: 856 20 97122771 US address: PO Box 13201, Tallahassee, FL 32317