[support] Converting a query to D7

[sivaji j.g]

On Tue, Oct 11, 2011 at 9:05 PM, Ms. Nancy Wichmann
<nan_wich at bellsouth.net> wrote:
> 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

I use this online service http://jonduell.com/sql-parser. It always
worked good for my needs.



--
Sivaji
http://sivaji.drupalgardens.com
@sivaji_ganesh in twitter
sivaji2009 at gmail.com
Gtalk / Skype: sivaji2009
Mobile: +91 9941 571 690