On 6 Feb 2013, at 5:53pm, Jamie Norrish <ja...@artefact.org.nz> wrote:
> On Tue, 2013-02-05 at 22:59 +0000, Simon Slavin wrote: > >>> (SELECT tn.ngram >>> FROM TextNGram tn, Text t >>> WHERE t.label != Text.label >>> AND t.label != '' >>> AND tn.text = t.id >>> AND tn.ngram = TextNGram.ngram >> Is the last line not a test to see that "Text.label != Text.label" and >> "TextNGram.ngram = TextNGram.ngram" ? > > I'm not sure what you mean here. The subselect should find any > TextNGram.ngram that does not share the label of a matching row in the > parent select, but which does share the actual ngram. Sorry, I didn't realise that the sub-SELECT had access to the main SELECT's values. My bad. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
