[support] Converting a query to D7

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.