<a href="http://upgrade.boombatower.com/tools/sql/inline">http://upgrade.boombatower.com/tools/sql/inline</a><div><br></div><div><div>db_select(&#39;user_badges_roles&#39;, &#39;ubr&#39;)</div><div>  -&gt;fields(&#39;ubr&#39;, array(&#39;rid&#39;, &#39;ubb&#39;))</div>
<div>  -&gt;join(&#39;user_badges_badges&#39;, &#39;ubb&#39;, &#39;ubb.bid = ubr.bid&#39;)</div><div>  -&gt;condition(&#39;ubr.rid&#39;, &#39;@todo Set the appropriate argument.&#39;)</div><div>  -&gt;execute();</div><div>
<br></div><div><br></div>----------------------------------<br>Dipen Chaudhary<br>Founder, QED42 : We build beautiful and scalable web strategies ( <a href="http://www.qed42.com">www.qed42.com</a> )<br>Blog: <a href="http://dipenchaudhary.com">dipenchaudhary.com</a><br>
Twitter: <a href="http://twitter.com/dipench">http://twitter.com/dipench</a><br><br>
<br><br><div class="gmail_quote">On Tue, Oct 11, 2011 at 9:05 PM, Ms. Nancy Wichmann <span dir="ltr">&lt;<a href="mailto:nan_wich@bellsouth.net">nan_wich@bellsouth.net</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div style="color:#000;background-color:#fff;font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>Before I pull any more hair out, can someone properly convert this to a D7 select query, please:</span></div>
<div style="font-family:Courier New,courier,monaco,monospace,sans-serif"><font size="2"><span>SELECT ubr.rid, ubb.* FROM {user_badges_roles} ubr INNER JOIN {user_badges_badges} ubb ON ubb.bid = ubr.bid WHERE ubr.rid = %d</span></font></div>
<div><br><span></span></div><div><span>It didn&#39;t seem all that difficult, but I keep getting errors.<br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></i></font></div>
 <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div></div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>