[support] [development] SQL Query Doubt
nan wich
nan_wich at bellsouth.net
Sun Apr 17 00:27:59 UTC 2011
<:avglsdata id=avglsdata>
I apologize, Ivan, in a quick read, I apparently confused your method with an
earlier method. Indeed the multiple-join-same-table method not only works, but
is the one often found in core (e.g. Taxonomy.module). I have not benchmarked
either one, but I am going to assume that some core developer has at some time
and that whoever that was discovered that either it is faster or that it is the
best cross-database implementation. I do, however, feel that the EXISTS method
is a more elegant and straight-forward solution, at least in MySql.
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________
From: Ivan Sergio Borgonovo
> Actually, Ivan's query won't work because each skill is on a
It happens it worked with real data on a real DB (no pun on
MySQL)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110416/0aa1ba21/attachment-0001.html
More information about the support
mailing list