[rt-users] howto use SearchBuilder with more tables

[Dennis]

Hi,

I am try to find out how to work with SearchBuilder. 
I have to make a search (with fields Name, Phone, some customer
fields, ...) for all User with role 'Requestor'. In Result must be show
User data and Ticket( open or new) for this users.

I write allreade some SQL:

select distinct
Users.id, Users.Name, Users.Organization, User.Zip, User.City,
User.Address1,Tickets.id
from Tickets , Groups , CachedGroupMembers , Principals , Users 
where
Tickets.Status='open' or Tickets.Status='new'
and Groups.Domain='RT::Ticket-Role' and Groups.Instance=Tickets.id
and CachedGroupMembers.GroupId = Groups.id and
Principals.id = CachedGroupMembers.MemberId and
Principals.Disabled = 0 and
Principals.PrincipalType='User' and
Users.id=Principals.id and
Groups.Type='Requestor';

but i don't known how to integrate it with RT (SearchBuilds)

Thanks for help