Almost there - just one issue left: I now receive a list of students per class - perfect. I also do a group_concat on the teachers (as a class could be taught by more than one) and so I I get the same teacher repeated a number of times at times. Any way I can apply a 'distinct' here?
> To: sqlite-users at mailinglists.sqlite.org > From: rsmith at rsweb.co.za > Date: Thu, 8 Oct 2015 23:34:05 +0200 > Subject: Re: [sqlite] Can this be done in SQLite? > > > > On 2015-10-08 11:30 PM, K. P. wrote: > > It does indeed work - had to make myself a simpler query than the real life > > one to see this. I probably had some other syntax error that I mistook for > > it... > > Thanks! > > Nice. > Are you logging the SQLite errors and error descriptions? It's usually > quite good at explaining where exactly your query goes wrong. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
