On Sun, Mar 3, 2013 at 2:48 PM, Tom Matrix <ratomat...@gmail.com> wrote:
> > The following query reports 18900080 rows (after some computation time): > Is this the correct answer for the query below? > > SELECT COUNT(*) > FROM entryintervals ei1 > JOIN interval2label il1 ON ei1.id = il1.entry_intervalid > JOIN labels la1 ON il1.labelid = la1.id > JOIN labelgroups lg1 ON la1.groupid = lg1.id > JOIN entries en1 ON ei1.entryid = en1.id > JOIN modules mo1 ON en1.moduleid = mo1.id > JOIN measurements me1 ON en1.measurementid = me1.id > JOIN entries en2 ON en1.measurementid = en2.measurementid > JOIN modules mo2 ON en2.moduleid = mo2.id > JOIN entryintervals ei2 ON en2.id = ei2.entryid > JOIN interval2label il2 ON ei2.id = il2.entry_intervalid > LEFT JOIN labels la2 ON il2.labelid = la2.id > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
