[support] [development] SQL Query Doubt

[nan wich]

<: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