Your join is performing a union, your queries could (and will) get
quite huge, since your getting a record for every tag. (so for two
tags you actually get two rows for that snippet). A left join will
provide you with everything, but you still get a row for every tag.
Even with a left join you wil
I've got some problem with the MANY-MANY relation in Web2Py. This is
my code-
http://pastie.textmate.org/903738
Now, the problem is that the query returns only those records which
have tags, not the ones without them. However, if I specify query|
db.snippets.id>0 or anything, it gives me garbled
2 matches
Mail list logo
