[support] Converting a query to D7

[Ms. Nancy Wichmann]

Before I pull any more hair out, can someone properly convert this to a D7 select query, please:
SELECT ubr.rid, ubb.* FROM {user_badges_roles} ubr INNER JOIN {user_badges_badges} ubb ON ubb.bid = ubr.bid WHERE ubr.rid = %d

It didn't seem all that difficult, but I keep getting errors.

 
Nancy 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20111011/f8b4418a/attachment.html